Dates & time Scalar

datetrunc()

Truncate to specified precision

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

datetrunc(part, timestamp)

Scalar
Overload link parttimestamp Returns
#01 VARCHARDATE TIMESTAMP
#02 VARCHARINTERVAL INTERVAL
#03 VARCHARTIMESTAMP TIMESTAMP
#04 VARCHARTIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE

Example

datetrunc example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.