Dates & time Scalar

datediff()

The number of partition boundaries between the timestamps

Reference: DuckDB 2.0.0

Arguments & returns

5 overloads

datediff(part, startdate, enddate)

Scalar
Overload link partstartdateenddate Returns
#01 VARCHARDATEDATE BIGINT
#02 VARCHARTIMETIME BIGINT
#03 VARCHARTIMESTAMP WITH TIME ZONETIMESTAMP WITH TIME ZONE BIGINT
#04 VARCHARTIMESTAMPTIMESTAMP BIGINT
#05 VARCHARTIMESTAMPTZ_NSTIMESTAMPTZ_NS BIGINT

Example

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

Engine example · Run to view results.