what does a sysdate+5 or anynumber mean? thanks
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
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..
Here is how you check: SQL> select sysdate+5 from dual; SYSDATE+5 ========= 24-APR-01 Sam
Thanx Sam Life is a journey, not a destination!
Did you have a chance to try this? Its Fun!! select sysdate + interval '100' month(3) from dual; It is pretty Sam
Forum Rules