EXTRACT
clauses

The

EXTRACT

clause extracts a Date/Time component from a

DateTime

type column.

Examples

SELECT EXTRACT(DAY FROM Time) AS "Day" FROM ...

SELECT EXTRACT(YEAR FROM Time) AS "Year" FROM ...

SELECT EXTRACT(MONTH FROM Time) AS "Month" FROM ...

SELECT EXTRACT(HOUR FROM Time) AS "Hour" FROM ...

SELECT EXTRACT(MINUTE FROM Time) AS "Minute" FROM ...

SELECT EXTRACT(SECOND FROM Time) AS "Second" FROM ...

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.