EXTRACT(): get the hour, minute, and second from a TIMESTAMP returned by TO_TIMESTAMP() : EXTRACT « Date Timezone « Oracle PL / SQL






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"