sysdate+5??

[looser]

what does a sysdate+5 or anynumber mean?


thanks

[chrisrlong]

Oracle dates are stored as the number of days since some base date (I forget when). The integer part of the date represents days. Therefore, any date + 5 means add 5 days to that date.

- Chris

[looser]

thats all I needed to know, thanks..

why is it so hard to me to search for something simple as this? arghhhh..

****, the burgers are burning..

[sambavan]

Here is how you check:

SQL> select sysdate+5 from dual;

SYSDATE+5
=========
24-APR-01


Sam

[sambavan]

Did you have a chance to try this? Its Fun!!


select sysdate + interval '100' month(3) from dual;


It is pretty

Sam