Dates & time Scalar

age()

Subtract arguments, resulting in the time difference between the two timestamps

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

age(timestamp)

Scalar
Overload link timestamp Returns
#01 TIMESTAMP INTERVAL
#02 TIMESTAMP WITH TIME ZONE INTERVAL

age(timestamp1, timestamp2)

Scalar
Overload link timestamp1timestamp2 Returns
#03 TIMESTAMP WITH TIME ZONETIMESTAMP WITH TIME ZONE INTERVAL
#04 TIMESTAMPTIMESTAMP INTERVAL

Example

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

Engine example · Run to view results.