EXTRACT( )

Go Up to Statement and Function Reference (Language Reference Guide)

Extracts date and time information from DATE, TIME, and TIMESTAMP values. Available in gpre, DSQL, and isql.

EXTRACT (part FROM value)

Argument	Description
<part>	YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, WEEKDAY, or YEARDAY; see the table below for data types and ranges of values
<value>	DATE, TIME, or TIMESTAMP value

Description: The value passed to the EXTRACT() expression must be a DATE, a TIME, or a TIMESTAMP. Extracting a part that does not exist in a data type results in an error. For example, a statement such as tEXTRACT (YEAR from aTime) would fail.

Note: The data type of part depends on which part is extracted.

Part extracted	Data type	Range
YEAR	SMALLINT	0–5400
MONTH	SMALLINT	1–12
DAY	SMALLINT	1–31
HOUR	SMALLINT	0–23
MINUTE	SMALLINT	0–59
SECOND	DECIMAL(6,4)	0–59.9999
WEEKDAY	SMALLINT	0–6 (0 = Sunday, 1 = Monday, etc.)
YEARDAY	SMALLINT	0–365

Example: EXTRACT(HOUR FROM StartTime);