Altering the ticket-number in RT

Hi all,

I found a possible solution for the problem of altering the ticket-
Number.

I know this is by no way RT-Specific, but the info I found is
outdated (1), so I thought, do an Wiki-Article after testing it, but
this doesnt work:

USE rt32;
BEGIN WORK;
LOCK TABLES Tickets WRITE;
INSERT INTO Tickets (id) VALUES
DATE_FORMAT(CURRENT_DATE,’%Y%m%d000’));
DELETE FROM Tickets where id = DATE_FORMAT(CURRENT_DATE,’%Y%m%d000’);
UNLOCK TABLES;
COMMIT;

the value is created, but not 20050126000 as expected.

(1)http://web.archive.org/web/20030415214945/fsck.com/rtfm/article.htm
l?id=5

I would be pleased if anybody could help. An wiki-article with the
working version will follow.
Bye for now,
Bis denne,
Joerg