Subject DateTime (timestamp) question
Author Leeway
I have several records with a timestamp field.
In these fields is the date and time of events.
I want to change the date of the events, but not the time.
e.g.
2001/01/01 20:15:00 must become 2001/05/01 20:15:00

So whet is the propper sql statement to change the date of a number
of records but not the time ?

Thanks aforehand
Lee