Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

EXTRACT Function

The EXTRACT function returns a date part, such as a day, month, or year, from a time stamp value or expression.

Syntax

Copy
EXTRACT ( datepart FROM { TIMESTAMP 'literal' | timestamp } )

Arguments

datepart

For possible values, see Dateparts for Date or Time Stamp Functions.

literal

A time stamp value, enclosed in single quotation marks and preceded by the TIMESTAMP keyword.

timestamp

A TIMESTAMP or TIMESTAMPTZ column, or an expression that implicitly converts to a time stamp or time stamp with time zone.

Return Type

INTEGER

Examples

Determine the week numbers for sales in which the price paid was $10,000 or more.

Copy
select salesid, extract(week from saletime) as weeknum from sales where pricepaid > 9999 order by 2; salesid | weeknum --------+--------- 159073 | 6 160318 | 8 161723 | 26 (3 rows)

Return the minute value from a literal time stamp value.

Copy
select extract(minute from timestamp '2009-09-09 12:08:43'); date_part ----------- 8 (1 row)