You can do sysdate + 1000 without problem.
Regards
/Joachim
klausk_at_my-dejanews.com wrote in message <6nafmp$csp$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I'm looking for a function to add or subtract days to a given date (usually
>sysdate), and have the new date returned:
>
>add 1000 days to sysdate is: ???? <in date format>
>add -545 days to sysdate is: ???? <in date format>
>
>in Transact SQL there is a date_add function, which allows to add integer
>values to each specified datepart, Oracle unfortunately hasn't.
>
>
>the add_months function doesn't fullfil the requirements
>
>Every help appreciated !
>
>Thx
>
>Klaus Kloeser
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jun 30 1998 - 06:09:48 CDT
