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