SQL> SELECT sysdate FROM Dual;
SYSDATE
---------
01-JUN-09
SQL> SELECT MONTHS_BETWEEN (SYSDATE,
2 TO_DATE ('01/01/2009', 'DD/MM/YYYY')
3 ) diff_in_months
4 FROM DUAL;
DIFF_IN_MONTHS
--------------
5
SQL>
No comments:
Post a Comment