Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

MONTHS_BETWEEN with to_date function

SQL> SQL> SELECT MONTHS_BETWEEN(TO_DATE('22SEP2006','ddMONyyyy'),   2    TO_DATE('13OCT2001','ddMONyyyy')) "Months difference"   3  FROM dual; Months difference -----------------        59.2903226 SQL> SQL> SQL>