Defering the DATETIME field values in a SQL table

[Charles Van Damme]

Dears,

I'm back in town (SQL) after a while and I don't remember how to increment at once all the values of DATETIME-type field in a table. Something like :
UPDATE visits SET Date = Date + 92534400 (Defer time, in ms)
But this generates the error "Incorrect datetime value '20051221734400.000000' for column 'Date' at row 1".
A tried to find the answer in the 'MySQL 6.0 Reference Manual' and in the Newbies and the Transactions - 'SQL Standards' forums, but without success.
Maybe you can also advise a good 'SQL transactions tutorial' on the web ?

Thanks for your help
Have a nice day - Chavadam