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.
>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 ?

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

Cheers,
H.




All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________