On this page

    Categories: Date/Time

    DATE_TRUNC

    Truncates the date or timestamp to the indicated precision.

    Syntax

    DATE_TRUNC(time_unit LITERAL, date_timestamp_expression DATE OR TIMESTAMP) → DATE

    • time_unit: The time unit that the date or timestamp needs to be truncated at. This must be the literal value of ‘YEAR’, ‘MONTH’, ‘DAY’, ‘HOUR’, ‘MINUTE’, or ‘SECOND’.
    • date_timestamp_expression: The date or timestamp to truncate. This value must be a literal in the date or timestamp format.

    Examples

    SELECT DATE_TRUNC('MONTH', '2021-12-24')
    -- 2021-12-01
    
    SELECT DATE_TRUNC('MINUTE', CAST('2021-12-24 12:28:33' as TIMESTAMP))
    -- 2021-12-24 12:28:00
    
    SELECT DATE_TRUNC('HOUR', '2021-12-24 12:28:33')
    -- 2021-12-24