[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Oracle Date Arithmetic



SQL> select Sysdate as Today, add_months(Sysdate, -1200) as LongAgo
  2  from dual;

TODAY       LONGAGO
----------- -----------
22-JAN-2004 22-JAN-1904

SQL> 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users