{"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","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"],"signature":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","signature_count":1,"slug":"uuid-extract-timestamp","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":"","description_zh_html":"","doc":{"anchor":"FUNC_UUID_EXTRACT_TABLE","file":"functions-uuid.html","slug":"18"},"group":"uuid","group_label":"Uuid Functions","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNC_UUID_EXTRACT_TABLE","file":"functions-uuid.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"uuid-extract-timestamp","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"uuid_extract_timestamp","Summary":"从版本 1 或 7 的 UUID 中提取 timestamp with time zone。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","BodyHTML":"从版本 1 或 7 的 UUID 中提取 \u003ccode\u003etimestamp with time zone\u003c/code\u003e。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。\u003cpre\u003euuid_extract_timestamp ( uuid ) → timestamp with time zone\u003c/pre\u003e从版本 1 或 7 的 UUID 中提取 \u003ccode\u003etimestamp with time zone\u003c/code\u003e。对于其他版本，该函数返回 null。注意，提取出的时间戳不一定与 UUID 生成时刻完全一致；这取决于生成该 UUID 的实现。","SourceRevision":"ca936764","ContentHash":"c9f822bc5c96cf4c289fe70f5aec6e9c14257908b7f9f7823c2b4c522c3fc4e4","Payload":{"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 的实现。","signatures":[{"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 的实现。","returns":"timestamp with time zone","text":"uuid_extract_timestamp ( uuid ) → timestamp with time zone","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}