Date arithmetic operations..

Shefu · #1 (**permalink**) 02-01-06, 04:45

is there any DATE arithmetic functions to add or subtract days to a date(TIMESTAMP) variable or column.

regards
Sn

Wim · #2 (**permalink**) 02-01-06, 05:16

Code:

select current date + 5 days, current timestamp - 5 days
from sysibm.sysdummy1;

umayer · #3 (**permalink**) 02-01-06, 05:16

yes, if the column is a DATE or TIMESTAMP simply code:

SELECT column-name + 1 DAY
FROM ...

or
SET column-name = CURRENT DATE + 1 MONTH ...

Shefu · #4 (**permalink**) 02-01-06, 07:45

Wim , Umayer thanks for the help, it works fine now