{"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"}],"derived_content_hash":"1e3e36978b00f1f582a659914a96b011a8b8c748a619c89411ee18dc6bc0561a","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"],"repair_provenance":{"original_source_revision":"english-manuals:8a57665012b17e2a550b85ac75aab982caf3a234e869633bafce1d6693c26b3a","receipt_sha256":"223b393568c07dacefdc4c078eda47156846bdb9789512e2eb0fcaa311afb4dd","repair":"wiki-repair-20261023"},"short_desc":"Reports whether PostgreSQL was built with support for 64-bit-integer dates and times.","short_desc_zh":"","source_rev":"wiki-repair-20261023:b167d16e8c4c3f7730be460d041e8eee75520e0af2a7bda7df844af3cecf5981","unit":"","vartype":"bool"}},"Definition":{"Collection":"guc","Key":"integer_datetimes","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"integer_datetimes","SourceRevision":"wiki-repair-20261023:b167d16e8c4c3f7730be460d041e8eee75520e0af2a7bda7df844af3cecf5981","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.","description_zh":"报告 PostgreSQL 是否在编译时启用了对 64 位整数日期和时间的支持。从 PostgreSQL 10 起，这个值总是 on。","description_zh_html":"\u003cp\u003e\n        报告 \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 是否在编译时启用了对 64 位整数日期和时间的支持。从 \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 10 起，这个值总是 \u003ccode class=\"literal\"\u003eon\u003c/code\u003e。\n       \u003c/p\u003e","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","translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-preset.html","sha256":"d0e95b9a81d5fdf853df26eba7dc096d96b9b45dadda13e0d0353aa72ac7a7b9"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"unit":null,"vartype":"bool","zh_from":"same-version-pgdoc"},"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":"wiki-repair-20261023:b167d16e8c4c3f7730be460d041e8eee75520e0af2a7bda7df844af3cecf5981","ContentHash":"4881b4108503820e0960c8e38ee1eb63d82adae431fbaa2ecc463a13cd1b7bf0","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":"en","Fallback":false,"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","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}