Dates & time Scalar

age()

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

Arguments & returns

4 overloads

Scalar

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

Scalar

Overload link	`timestamp`	`timestamp`	Returns
#03	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`	`INTERVAL`
#04	`TIMESTAMP`	`TIMESTAMP`	`INTERVAL`

SELECT age(TIMESTAMP '2001-04-10', TIMESTAMP '1992-09-20');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.