[rt-users] Changing the starting Ticket-Number

[Joerg Herbert]

Hi all,

i know this was asked before, but I didn't find it in the archives. 
How can I change the ticket-number to a format like yyyymmddnnn with

yyyymmdd as a date-Format and nnn being an Integer from 000 to 999?

I know that I have to do it via cron, but didn't find the proper 
mysql-Statement.

Thanks in advance for your help.

-- 
Bye for now, 
Bis denne,
                   Joerg