I'm trying to increment a DateTime field by given number of days.

I tried using the sql statement "UPDATE XTABLE SET MY_DATE=MYDATE + 7"
but this has no effect at all.

Help please !!

Norman
Desktop Financials Ltd

Norman,

> I'm trying to increment a DateTime field by given number of days.
>
> I tried using the sql statement "UPDATE XTABLE SET MY_DATE=MYDATE + 7"
> but this has no effect at all.

That's because TIMESTAMP field values are internally stored as
cumulative milliseconds, so what you are in fact doing is adding 7
milliseconds to MYDATE, not 7 days.
So, to add 7 days to MYDATE you must actually add
604800000 = 7*24*60*60*1000 = number of milliseconds in 7 days :

  UPDATE XTABLE SET MY_DATE=MYDATE + 604800000

--
Fernando Dias
[Team Elevate]

Fernando,

Thanks for the quick response

Norman