{"Entry":{"collection":"guc","key":"integer_datetimes","name":"integer_datetimes","aliases":[],"metadata":{"baseline":false,"boot_human":"Not specified","boot_val":null,"category":"Preset Options","category_zh":"","changed_in":["14"],"changes":[{"documentation_changed":false,"fields":{},"from":"7.4","status":"added","to":"8.0"},{"documentation_changed":true,"fields":{},"from":"8.0","status":"changed","to":"8.1"},{"documentation_changed":true,"fields":{},"from":"8.3","status":"changed","to":"8.4"},{"documentation_changed":true,"fields":{},"from":"9.6","status":"changed","to":"10"},{"documentation_changed":false,"fields":{"short_desc":{"from":"Datetimes are integer based.","to":"Shows whether datetimes are integer based."}},"from":"13","status":"changed","to":"14"}],"content_hash":"93ec0586e2fadb6a9a7af2f8b2c116ce5d3d9d5ba0c52e586f6ddb22fe2dedf3","context":"","default_changed_in":[],"default_history":[{"from":"9.0","to":"19","value":"on"}],"editorial":{"advice":{"olap":"Not tunable. Use integer_datetimes to verify format, build, or resource assumptions on analytical nodes and keep every read/write candidate compatible.","oltp":"Not tunable. Record integer_datetimes as a deployment/capability fact; if it is unexpected, fix the binary, initdb, or database-creation process rather than trying SET.","small":"Not tunable. Preserve it in inventory and incident reports; do not custom-build or rebuild merely to change it without a demonstrated compatibility need."},"mechanism":["Shows whether datetimes are integer based. It is read-only and cannot be changed with SET or configuration-file edits.","It reports the server's datetime representation. All measured PG9.0–19 Beta 3 builds use integer datetimes; applications should treat it as compatibility metadata.","Interpret it with server_version, server_version_num, server_encoding. Applications and operations tooling may read integer_datetimes for capability or environment detection, but cannot SET it; cross-cluster comparisons must account for build, initdb, and current-database differences."],"pitfalls":["Trying to change read-only integer_datetimes with SET or a configuration file.","Assuming every cluster, database, or vendor build reports the same value.","Ignoring the value in file-format or feature-compatibility checks.","Treating reported metadata as a performance target instead of an environment fact."],"references":[{"title":"PostgreSQL 19 Beta 4: integer_datetimes","url":"https://www.postgresql.org/docs/19/runtime-config-preset.html#GUC-INTEGER-DATETIMES"},{"title":"PostgreSQL 19 release notes","url":"https://www.postgresql.org/docs/19/release-19.html"}],"related":["server_version","server_version_num","server_encoding","ssl_library","debug_assertions","block_size"],"summary":"integer_datetimes — Shows whether datetimes are integer based. Observed in PG9.0–19 Beta 4; its last measured boot default is on in PG19 Beta 4, with internal context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA."},"enumvals":[],"first_version":"8.0","group":"Preset Options","group_slug":"preset","imported_at":"2026-09-27T17:57:31.398342+08:00","intro_commit":{},"key":"integer_datetimes","last_version":"20","max_val":"","min_val":"","name":"integer_datetimes","position":180,"present_in":["8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"short_desc":"Reports whether PostgreSQL was built with support for 64-bit-integer dates and times.","short_desc_zh":"","source_rev":"english-manuals:8a57665012b17e2a550b85ac75aab982caf3a234e869633bafce1d6693c26b3a","unit":"","vartype":"bool"}},"Definition":{"Collection":"guc","Key":"integer_datetimes","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"integer_datetimes","SourceRevision":"english-manuals:8a57665012b17e2a550b85ac75aab982caf3a234e869633bafce1d6693c26b3a","Facts":{"boot_val":"on","category":"Preset Options","context":"internal","description":"Reports whether PostgreSQL was built with support for 64-bit-integer dates and times. As of PostgreSQL 10, this is always on.","doc":{"anchor":"GUC-INTEGER-DATETIMES","file":"runtime-config-preset.html","lang":"en","sha256":"4dbfec727b9cee838adefb8a766217748d91ab90190b452a58cec737459582ce","slug":"18"},"documented":true,"enumvals":null,"extra_desc":null,"lang":"en","max_val":null,"metadata_version":"18","min_val":null,"name":"integer_datetimes","short_desc":"Shows whether datetimes are integer based.","source":"pg-settings-source-snapshot","unit":null,"vartype":"bool"},"ManualEvidence":{"doc":{"anchor":"GUC-INTEGER-DATETIMES","file":"runtime-config-preset.html","lang":"en","sha256":"4dbfec727b9cee838adefb8a766217748d91ab90190b452a58cec737459582ce","slug":"18"}},"MeasuredEvidence":{"metadata_version":"18"}},"Text":{"Collection":"guc","Key":"integer_datetimes","SourceDatabase":"center","Version":"18","Locale":"en","Title":"integer_datetimes","Summary":"Reports whether PostgreSQL was built with support for 64-bit-integer dates and times. As of PostgreSQL 10, this is always on.","BodyHTML":"\u003cp\u003eReports whether PostgreSQL was built with support for 64-bit-integer dates and times. As of PostgreSQL 10, this is always on.\u003c/p\u003e","SourceRevision":"english-manuals:8a57665012b17e2a550b85ac75aab982caf3a234e869633bafce1d6693c26b3a","ContentHash":"e968a647d7767035d728a0036cc8b47d869f3457de3845f270c1b06c15b8acc1","Payload":{"description":"Reports whether PostgreSQL was built with support for 64-bit-integer dates and times. As of PostgreSQL 10, this is always on."}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}