Skip to main content
Version: current [25.x]

Categories: Date/Time

DATE_PART

Return subfields such as year or hour from date or timestamp values.

Syntax​

DATE_PART(field string, source date or timestamp) → integer​

  • field: Must be one of the following: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND.
  • source: The value from which to extract the subfield

Examples

DATE_PART example 
select date_part('year', timestamp '2021-04-01 15:27:32')
-- 2021
DATE_PART example 
select date_part('month', date '2021-04-01')
-- 4