Subject | DateTime (timestamp) question |
---|---|
Author | Leeway |
Post date | 2001-07-05T06:49:35Z |
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
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