Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select months_between( sysdate, date1971-05-18 )

SQL> SQL> select months_between( sysdate, date'1971-05-18' )   2  from dual; MONTHS_BETWEEN(SYSDATE,DATE'1971-05-18') ----------------------------------------                               444.958945 1 row selected. SQL> --