Materialize Logo

date_trunc Function

date_trunc returns a timestamp with the “floor value” of the specified time component, i.e. the largest time component less than or equal to the provided value.

Signatures

date_trunc ( ' microseconds milliseconds second minute hour day week month quarter year decade century millenium ' , ts_val )
Parameter Type Description
ts_val timestamp, timestamp with time zone The value you want to truncate.

Return value

date_trunc returns a timestamp value.

Examples

SELECT date_trunc('hour', TIMESTAMP '2019-11-26 15:56:46.241150') AS hour_trunc;
          hour_trunc
-------------------------------
 2019-11-26 15:00:00.000000000

```sql SELECT date_trunc('year', TIMESTAMP '2019-11-26 15:56:46.241150') AS year_trunc; ``` ```nofmt year_trunc ------------------------------- 2019-01-01 00:00:00.000000000 ```
Did this info help?
Yes No