DATETRUNC

Truncates a date to the beginning of the specified period

DATETRUNC(date, date part)

Truncate a date, or a series of dates, to the date part specified on input.

Arguments

Argument	Description
date	Date/time value(s)
date part	Part of the date/time value(s) to truncate by

Output

Date(s) corresponding to the start of the period specified by date part

Example