Functions / Date/Time Functions And Operators
Create interval from years, months, weeks, days, hours, minutes and seconds fields, each of which can default to zero
Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20
make_interval ( [ years int [, months int [, weeks int [, days int [, hours int [, mins int [, secs double precision ]]]]]]] ) → intervalCreate interval from years, months, weeks, days, hours, minutes and seconds fields, each of which can default to zero
make_interval(days => 10) → 10 days
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source