select months_between( sysdate, date'2001-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> --
Related examples in the same category