![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() Term: MONTHS_BETWEEN
Definition: MONTHS_BETWEEN (D1, D2) where D1 and D2 are of date datatype. Example Usage: As shown in the SQL statement below, if the first argument date is greater than second argument date, the result is positive. SQL> SELECT MONTHS_BETWEEN(TO_DATE('10-12-2010','DD-MM-YYYY HH24:MI:SS'), If the first argument date is less than the second argument date, the result is negative. SQL> SELECT MONTHS_BETWEEN(SYSDATE, SYSDATE+1 ) DIFF Related Links: Related Code Snippets:
![]() |
![]() |
Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 111 users online © 2009 psoug.org |