SQL · Date and time functions

age()

A human-readable interval between timestamps. PostgreSQL.

sqlRunnable example sql course

Syntax

age(later, earlier)

Example

Open in the lab

-- PostgreSQL
-- SELECT age(now(), '2026-01-01');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.