Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --