DATE_TRUNC

Use DATE_TRUNC to truncate a timestamp and convert it to the specified datetime unit. The first parameter is the datetime unit. The parameter is enclosed in single quotes. The second parameter is the timestamp value.

Syntax

DATE_TRUNC('YYYY',timestamp_expression)