extract ( field from timestamp ) → numeric → numericGet timestamp subfield; see Section 9.9.1
extract
Get timestamp subfield; see Section 9.9.1
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
Get timestamp subfield; see Section 9.9.1
Signatures and overloads
extract ( field from interval ) → numeric → numericGet interval subfield; see Section 9.9.1
EXTRACT(field FROM source)The
extract function retrieves subfields such as year or hour from date/time values. source must be a value expression of type timestamp, date, time, or interval. (Timestamps and times can be with or without time zone.) field is an identifier or string that selects what field to extract from the source value. Not all fields are valid for every input data type; for example, fields smaller than a day cannot be extracted from a date, while fields of a day or more cannot be extracted from a time. The extract function returns values of type numeric.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:724b8b2cb077f6056ce13920192ecf1455f2d77cf4f497e810fc2bfb0fc1ce00
Text language: en · wiki-repair-20261023:724b8b2cb077f6056ce13920192ecf1455f2d77cf4f497e810fc2bfb0fc1ce00