| Parameter | Type |
|---|---|
dateValue | datetime, date, time, datetimestamp, gyear, gyearmonth |
units | string |
Returns: any
Example
query:
SELECT DATE_TRUNC(CAST("2018-01-02" AS DATE), "month")results:
| date_trunc |
|---|
| 2018-01-01 |
DATE_TRUNC
The date function used to truncate a date or datetime value to the start of a given unit of duration. Takes two arguments, the date to truncate and the unit of duration (one of "year", "decade", "century", "quarter", "month", "week", "day", "hour", "minute", "second", or "millisecond"). The function returns a value of the same type as it's first argument.