PostgreSQL Function Reference

MAKE_INTERVAL

Creates an interval from specified units.

PostgreSQL 17.5

MAKE_INTERVAL(years, months, weeks, days, hours, mins, secs)

years

Years component

months

Months component

weeks

Weeks component

days

Days component

hours

Hours component

mins

Minutes component

secs

Seconds component

Examples

PostgreSQL 17.5

SELECT MAKE_INTERVAL(0, 0, 0, 0, 0, 0, 3661)