Dates & time Scalar

datetrunc()

Truncate to specified precision

Arguments & returns

4 overloads

Scalar

Overload link	`part`	`timestamp`	Returns
#01	`VARCHAR`	`DATE`	`TIMESTAMP`
#02	`VARCHAR`	`INTERVAL`	`INTERVAL`
#03	`VARCHAR`	`TIMESTAMP`	`TIMESTAMP`
#04	`VARCHAR`	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`

SELECT datetrunc('hour', TIMESTAMPTZ '1992-09-20 20:38:40');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  date_trunc('hour', TIMESTAMPTZ '1992-09-20 20:38:40');