EXTRACT_FROM_DATE

All functions > DATE AND TIME > EXTRACT_FROM_DATE

Returns the part of the given timestamp in the given unit.

Signatures

Returns: The extracted component as BIGINT

EXTRACT_FROM_DATE(timestamp: DATE, unit: VARCHAR) → BIGINT

Notes

• Extracts a specific component from a date/time value
• Common units: 'year', 'month', 'day', 'hour', 'minute', 'second'
• Also supports: 'dow' (day of week), 'doy' (day of year), 'week'
• Works with DATE, TIMESTAMP, and INTERVAL types
• Day of week: 1 = Monday, 7 = Sunday
• Useful for grouping by time components or filtering by date parts

Examples

SELECT
    f1 := EXTRACT_FROM_DATE(FROM_ISO8601_TIMESTAMP('2024-03-15T10:30:45'), 'year'),  -- Extract year component
    f2 := EXTRACT_FROM_DATE(FROM_ISO8601_TIMESTAMP('2024-03-15T10:30:45'), 'month'),  -- Extract month component
    f3 := EXTRACT_FROM_DATE(FROM_ISO8601_TIMESTAMP('2024-03-15T10:30:45'), 'day'),  -- Extract day component
    f4 := EXTRACT_FROM_DATE(FROM_ISO8601_TIMESTAMP('2024-03-15T10:30:45'), 'hour')  -- Extract hour component
;