Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. EXTRACT(DAY FROM TO_DATE(01-JAN-2005 19
SQL>
SQL> select EXTRACT(DAY FROM TO_DATE('01-JAN-2005 19:15:26',
  2      'DD-MON-YYYY HH24:MI:SS')) AS DAY from dual;
       DAY
----------
         1
SQL>