{"Entry":{"collection":"func","key":"uuidv7","name":"uuidv7","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"17","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"18"}],"content_hash":"76a0ebfa78bda007f7c92089592994e85a61cf3d765095ff138a395c2d9e39a4","first_version":"18","group":"uuid","group_label":"Uuid Functions","groups":["uuid"],"imported_at":"2026-09-14T21:49:48.756093+08:00","last_version":"20","name":"uuidv7","name_key":"uuidv7","position":14004,"present_in":["18","19","20"],"signature":"uuidv7 ( [ shift interval ] ) → uuid","signature_count":1,"slug":"uuidv7","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"Generates a version 7 (time-ordered) UUID.","summary_zh":""}},"Definition":{"Collection":"func","Key":"uuidv7","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"uuidv7","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNC_UUID_GEN_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":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"","description_zh_html":"","examples":[{"expr":"uuidv7()","result":"019535d9-3df7-79fb-b466-fa907fa17f9e"}],"html":"\u003ccode class=\"function\"\u003euuidv7\u003c/code\u003e ( [ \u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003euuid\u003c/code\u003e","returns":"uuid","text":"uuidv7 ( [ shift interval ] ) → uuid","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNC_UUID_GEN_TABLE","file":"functions-uuid.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"uuidv7","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"uuidv7","Summary":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift会按给定的interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","BodyHTML":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e会按给定的\u003ccode\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。\u003cpre\u003euuidv7 ( [ shift interval ] ) → uuid\u003c/pre\u003e生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e会按给定的\u003ccode\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","SourceRevision":"1b5ca64c","ContentHash":"cec3474270eddfadc4efd8df5d7c41d9a23cf145edb2c8d37b166280046084e3","Payload":{"description_zh":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift会按给定的interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","description_zh_html":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e会按给定的\u003ccode class=\"type\"\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","signatures":[{"description_zh":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift会按给定的interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","description_zh_html":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e会按给定的\u003ccode class=\"type\"\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","returns":"uuid","text":"uuidv7 ( [ shift interval ] ) → uuid","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"871c0ad9b437b86dd1b2c91381f403486057dfb69db08642e03fa85e1100cf29","Text":"uuidv7 ( [ shift interval ] ) → uuid","Returns":"uuid","Payload":{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"","description_zh_html":"","examples":[{"expr":"uuidv7()","result":"019535d9-3df7-79fb-b466-fa907fa17f9e"}],"html":"\u003ccode class=\"function\"\u003euuidv7\u003c/code\u003e ( [ \u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003euuid\u003c/code\u003e","returns":"uuid","text":"uuidv7 ( [ shift interval ] ) → uuid","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}