Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
EXTRACT(MONTH FROM TO_DATE(01-JAN-2005 19
SQL> SQL> select EXTRACT(MONTH FROM TO_DATE('01-JAN-2005 19:15:26', 2 'DD-MON-YYYY HH24:MI:SS')) As MONTH from dual; MONTH ---------- 1 SQL>