DATETRUNC
datetrunc(part, timestamp)
Section titled “datetrunc(part, timestamp)”- part: VARCHAR
- timestamp: DATE
Example
Section titled “Example”SELECT datetrunc('hour', TIMESTAMPTZ '1992-09-20 20:38:40');SELECT datetrunc('hour', TIMESTAMPTZ '1992-09-20 20:38:40');