DATE_PART

Retrieves the designated portion of a date or timestamp.

See also: EXTRACT

Syntax

DATE_PART(
  YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND |
  DOW | DOY | EPOCH | ISODOW | YEARWEEK | MILLENNIUM,
  <date_or_timestamp_expr>
)

Return Type

Integer.

Examples

This example demonstrates how to use DATE_PART to extract various components—such as year, month, ISO week day, year-week combination, and millennium—from the current timestamp:

SELECT
  DATE_PART(YEAR, NOW())        AS year_part,
  DATE_PART(QUARTER, NOW())     AS quarter_part,
  DATE_PART(MONTH, NOW())       AS month_part,
  DATE_PART(WEEK, NOW())        AS week_part,
  DATE_PART(DAY, NOW())         AS day_part,
  DATE_PART(HOUR, NOW())        AS hour_part,
  DATE_PART(MINUTE, NOW())      AS minute_part,
  DATE_PART(SECOND, NOW())      AS second_part,
  DATE_PART(DOW, NOW())         AS dow_part,
  DATE_PART(DOY, NOW())         AS doy_part,
  DATE_PART(EPOCH, NOW())       AS epoch_part,
  DATE_PART(ISODOW, NOW())      AS isodow_part,
  DATE_PART(YEARWEEK, NOW())    AS yearweek_part,
  DATE_PART(MILLENNIUM, NOW())  AS millennium_part;

┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ year_part │ quarter_part │ month_part │ week_part │ day_part │ hour_part │ minute_part │ second_part │ dow_part │ doy_part │     epoch_part    │ isodow_part │ yearweek_part │ millennium_part │
├───────────┼──────────────┼────────────┼───────────┼──────────┼───────────┼─────────────┼─────────────┼──────────┼──────────┼───────────────────┼─────────────┼───────────────┼─────────────────┤
│      2025 │            2 │          4 │        16 │       16 │        18 │          10 │          10 │        3 │      106 │ 1744827010.257671 │           3 │        202516 │               3 │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘