date_trunc function
date_trunc computes ts_val’s “floor value” of the specified time component,
i.e. the largest time component less than or equal to the provided value.
To align values along arbitrary values, see date_bin.
Signatures
| Parameter | Type | Description |
|---|---|---|
| ts_val | timestamp, timestamp with time zone |
The value you want to truncate. |
Return value
date_trunc returns the same type as ts_val.
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
SELECT date_trunc('year', TIMESTAMP '2019-11-26 15:56:46.241150') AS year_trunc;
year_trunc
-------------------------------
2019-01-01 00:00:00.000000000