Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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>