date_bin ( interval, timestamp, timestamp ) → timestamp → timestampBin input into specified interval aligned with specified origin; see Section 9.9.3
date_bin
Bin input into specified interval aligned with specified origin; see Section 9.9.3
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
- group
- datetime
- group label
- 时间/日期函数和操作符
- lang
- en
- layout
- table-new
- pages
- functions-datetime.html
- prose only
- false
Definition PG 18
Bin input into specified interval aligned with specified origin; see Section 9.9.3
Signatures and overloads
date_bin(stride, source, origin)
source is a value expression of type timestamp or timestamp with time zone. (Values of type date are cast automatically to timestamp.) stride is a value expression of type interval. The return value is likewise of type timestamp or timestamp with time zone, and it marks the beginning of the bin into which the source is placed.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
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:eb2fc95fdc5365ead48ba5b3c28cfc1f3be26f8313172639c558d9f13749192f
Text language: en · wiki-repair-20261023:eb2fc95fdc5365ead48ba5b3c28cfc1f3be26f8313172639c558d9f13749192f