Subject Re: [ib-support] DateTime (timestamp) question
Author Helen Borrie
At 06:49 AM 05-07-01 +0000, you wrote:
>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.
>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 ?

update aTable set TheTimestamp = TheTimestamp + 31 + 28 + 31 + 30


All for Open and Open for All
InterBase Developer Initiative ยท