EXTRACT(): get the hour, minute, and second from a TIMESTAMP returned by TO_TIMESTAMP()
SQL>
SQL>
SQL> --EXTRACT(): get the hour, minute, and second from a TIMESTAMP returned by TO_TIMESTAMP():
SQL>
SQL> SELECT
2 EXTRACT(HOUR FROM TO_TIMESTAMP('01-JAN-2005 19:15:26',
3 'DD-MON-YYYY HH24:MI:SS')) AS HOUR,
4 EXTRACT(MINUTE FROM TO_TIMESTAMP('01-JAN-2005 19:15:26',
5 'DD-MON-YYYY HH24:MI:SS')) AS MINUTE,
6 EXTRACT(SECOND FROM TO_TIMESTAMP('01-JAN-2005 19:15:26',
7 'DD-MON-YYYY HH24:MI:SS')) AS SECOND
8 FROM dual;
HOUR MINUTE SECOND
---------- ---------- ----------
19 15 26
SQL>
Related examples in the same category
1. | The EXTRACT() function returns the value of a specified datetime field from a datetime or interval value expression. | | |
2. | EXTRACT(): return a year, month, day, hour, minute, second, or time zone from x | | |
3. | EXTRACT(MONTH FROM TO_DATE('01-JAN-2005 19:15:26', 'DD-MON-YYYY HH24:MI:SS')) | | |
4. | EXTRACT(DAY FROM TO_DATE('01-JAN-2005 19:15:26', 'DD-MON-YYYY HH24:MI:SS')) | | |
5. | EXTRACT(TIMEZONE_HOUR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM') | | |
6. | EXTRACT(TIMEZONE_MINUTE FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM')) | | |
7. | EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR')) | | |
8. | EXTRACT(TIMEZONE_REGION FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR')) | | |
9. | select extract( year from add_months(sysdate,36) ) "3 Years Out" | | |