make_interval

Create interval from years, months, weeks, days, hours, minutes and seconds fields, each of which can default to zero

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: datetime
group label: 时间/日期函数和操作符
lang: en
layout: table-new
pages: functions-datetime.html
prose only: false

Definition PG 18

Create interval from years, months, weeks, days, hours, minutes and seconds fields, each of which can default to zero

Signatures and overloads

make_interval ( [years int [, months int [, weeks int [, days int [, hours int [, mins int [, secs double precision]]]]]]] ) → interval → interval

Create interval from years, months, weeks, days, hours, minutes and seconds fields, each of which can default to zero

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-datetime.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"8c5053713aeaacfbe4cb00effc61f10d457c98b2a29c724b10b93819a087ea95","version":"18.7"},{"file":"functions-datetime.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"c3efdd1c3df6795c73dfea2ecec17ca31ff37da23d758083a581d75445851f0c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:b35403146b87abb6ed43dfe103dc545e13a8bcaac90ee8f55997e27485ef4ab2

Text language: en · wiki-repair-20261023:b35403146b87abb6ed43dfe103dc545e13a8bcaac90ee8f55997e27485ef4ab2