DATE_TRUNC
date_trunc(part, timestamp)
Section titled “date_trunc(part, timestamp)”- part: VARCHAR
- timestamp: INTERVAL
Example
Section titled “Example”SELECT date_trunc('hour', TIMESTAMPTZ '1992-09-20 20:38:40');SELECT date_trunc('hour', TIMESTAMPTZ '1992-09-20 20:38:40');