Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select months_between( sysdate, date2001-01-01 )

SQL> SQL> select months_between( sysdate, date'2001-01-01' )   2  from dual; MONTHS_BETWEEN(SYSDATE,DATE'2001-01-01') ----------------------------------------                               89.5073324 1 row selected. SQL> SQL> --