{"Entry":{"collection":"func","key":"uuid-extract-timestamp","name":"uuid_extract_timestamp","aliases":[],"metadata":{"changed_in":["18"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"17"},{"descriptions_changed":true,"doc_overhaul":false,"from":"17","group_changed":null,"signatures":{"added":["uuid_extract_timestamp ( uuid ) → timestamp with time zone"],"removed":["uuid_extract_timestamp (uuid) → timestamp with time zone"]},"status":"changed","to":"18"},{"descriptions_changed":true,"doc_overhaul":false,"from":"19","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"20"}],"content_hash":"5ab977df6f20bd2960be5c49bac5e05895a94466ddb9e1a25f2d9d2f1cc596b6","derived_content_hash":"13cd7620bf5a52d2bdc60389f6a26dfff346e75e3dcd5d49888f9e21fd816d63","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:c86b05cd2938f42830488be9a9ec953c8d0e129b1c796d8f9b92b92e21013586","versions":{"17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"17","group":"uuid","group_label":"Uuid Functions","groups":["uuid"],"imported_at":"2026-09-14T21:49:48.754903+08:00","last_version":"20","name":"uuid_extract_timestamp","name_key":"uuid_extract_timestamp","position":14001,"present_in":["17","18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"91583c515ae29bd14c983af55f6e7b681e221fbefbba96ab6bfcfe3e5bc77890","repair":"wiki-repair-20261023"},"signature":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","signature_count":1,"slug":"uuid-extract-timestamp","source_rev":"wiki-repair-20261023:c86b05cd2938f42830488be9a9ec953c8d0e129b1c796d8f9b92b92e21013586","summary":"Extracts a timestamp with time zone from a UUID of version 1, 6, or 7.","summary_zh":""}},"Definition":{"Collection":"func","Key":"uuid-extract-timestamp","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"uuid-extract-timestamp","SourceRevision":"wiki-repair-20261023:c86b05cd2938f42830488be9a9ec953c8d0e129b1c796d8f9b92b92e21013586","Facts":{"description":"Extracts a timestamp with time zone from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_html":"Extracts a \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_zh":"从版本 1 或 7 的 UUID 中提取 timestamp with time zone。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","description_zh_html":"从版本 1 或 7 的 UUID 中提取 \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","doc":{"anchor":"FUNC_UUID_EXTRACT_TABLE","file":"functions-uuid.html","sha256":"1145bc769b573b2bdb5619ef98fc49d54db67f2fe7bd4bec69f14c025e66453c","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-uuid.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"1145bc769b573b2bdb5619ef98fc49d54db67f2fe7bd4bec69f14c025e66453c","version":"18.7"},{"file":"functions-uuid.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"59821fb93e96c7c39838320986580f60a79cc09b1cd2d8ab9bb738768941e05a","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"uuid","group_label":"UUID 函数","lang":"en","layout":"table-new","pages":["functions-uuid.html"],"prose_only":false,"signatures":[{"description":"Extracts a timestamp with time zone from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_html":"Extracts a \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_zh":"从版本 1 或 7 的 UUID 中提取 timestamp with time zone。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","description_zh_html":"从版本 1 或 7 的 UUID 中提取 \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","examples":[{"expr":"uuid_extract_timestamp('019535d9-3df7-79fb-b466-fa907fa17f9e' :: uuid)","result":"2025-02-23 21:46:24.503-05"}],"html":"\u003ccode class=\"function\"\u003euuid_extract_timestamp\u003c/code\u003e ( \u003ccode class=\"type\"\u003euuid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etimestamp with time zone\u003c/code\u003e","returns":"timestamp with time zone","text":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-uuid.html","sha256":"151c63c49d5c4d62b5b90376ab82e5db7c6370a7daa7d58eb51c7b482156efdc"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNC_UUID_EXTRACT_TABLE","file":"functions-uuid.html","sha256":"1145bc769b573b2bdb5619ef98fc49d54db67f2fe7bd4bec69f14c025e66453c","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"uuid-extract-timestamp","SourceDatabase":"center","Version":"18","Locale":"en","Title":"uuid_extract_timestamp","Summary":"Extracts a timestamp with time zone from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","BodyHTML":"Extracts a \u003ccode\u003etimestamp with time zone\u003c/code\u003e from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","SourceRevision":"wiki-repair-20261023:c86b05cd2938f42830488be9a9ec953c8d0e129b1c796d8f9b92b92e21013586","ContentHash":"7a4aa4ec18f3351e30eb0273e3eba1288f578e2a9d66200bc1cd1b0cd8edd761","Payload":{"description":"Extracts a timestamp with time zone from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_html":"Extracts a \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","signatures":[{"description":"Extracts a timestamp with time zone from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_html":"Extracts a \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_zh":"从版本 1 或 7 的 UUID 中提取 timestamp with time zone。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","description_zh_html":"从版本 1 或 7 的 UUID 中提取 \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","examples":[{"expr":"uuid_extract_timestamp('019535d9-3df7-79fb-b466-fa907fa17f9e' :: uuid)","result":"2025-02-23 21:46:24.503-05"}],"html":"\u003ccode class=\"function\"\u003euuid_extract_timestamp\u003c/code\u003e ( \u003ccode class=\"type\"\u003euuid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etimestamp with time zone\u003c/code\u003e","returns":"timestamp with time zone","text":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"95d07d5387f9557475d51d221f79576d9509af5cef763b7a454ba38e8d0e78f5","Text":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","Returns":"timestamp with time zone","Payload":{"description":"Extracts a timestamp with time zone from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_html":"Extracts a \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e from a UUID of version 1 or 7. For other versions, this function returns null. Note that the extracted timestamp is not necessarily exactly equal to the time the UUID was generated; this depends on the implementation that generated the UUID.","description_zh":"从版本 1 或 7 的 UUID 中提取 timestamp with time zone。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","description_zh_html":"从版本 1 或 7 的 UUID 中提取 \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","examples":[{"expr":"uuid_extract_timestamp('019535d9-3df7-79fb-b466-fa907fa17f9e' :: uuid)","result":"2025-02-23 21:46:24.503-05"}],"html":"\u003ccode class=\"function\"\u003euuid_extract_timestamp\u003c/code\u003e ( \u003ccode class=\"type\"\u003euuid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etimestamp with time zone\u003c/code\u003e","returns":"timestamp with time zone","text":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}