TIMESTAMP_TRUNC()
function rounds a timestamp to a specific day_time
granularity, resulting in a truncated timestamp.
day_time
can be replaced with various time values as follows:
SECOND
MINUTE
HOUR
DAY
MONTH
YEAR
TIMESTAMP_TRUNC()
- HourTIMESTAMP_TRUNC()
- MinuteTIMESTAMP_TRUNC()
function - Year