EXTRACT (DateComponentKeyword FROM char)

CREATE TABLE dt_table (date_col DATE, timestamp_col TIMESTAMP, time_col TIME); INSERT INTO dt_table VALUES ('2003-12-29', '2004-02-17-14.20.06.131000', '02:20:34'); 1 row affected SELECT date_col, EXTRACT(DAY FROM date_col) AS result FROM dt_table; 1 row selected date_col result ---------- ----------- 2003-12-29 29 SELECT date_col, EXTRACT(MONTH FROM date_col) AS result FROM dt_table; 1 row selected date_col result ---------- ----------- 2003-12-29 12 SELECT timestamp_col, EXTRACT(YEAR FROM timestamp_col) AS result FROM dt_table; 1 row selected timestamp_col result -------------------------- ----------- 2004-02-17-14.20.06.131000 2004 SELECT time_col, EXTRACT(HOUR FROM time_col) AS result FROM dt_table; 1 row selected time_col result -------- ----------- 02:20:34 2 SELECT timestamp_col, EXTRACT(MINUTE FROM timestamp_col) AS result FROM dt_table; 1 row selected timestamp_col result -------------------------- ----------- 2004-02-17-14.20.06.131000 20 SELECT time_col, EXTRACT(SECOND FROM time_col) AS result FROM dt_table; 1 row selected time_col result -------- ----------- 02:20:34 34 SELECT timestamp_col, EXTRACT(MICROSECOND FROM timestamp_col) AS result FROM dt_table; 1 row selected timestamp_col result -------------------------- ----------- 2004-02-17-14.20.06.131000 131000