{"capability":{"Key":"sqljson-datetime","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"SQL/JSON: datetime()","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"SQL/JSON: datetime()","NameLocale":"en","GroupKey":"json","GroupName":"JSON","GroupLocale":"en","Ordinal":6,"GroupOrder":6,"Facts":{"feature":{"description":"The SQL/JSON path `datetime()` function in JSON path expressions converts valid date and time formats (e.g. ISO 8601) to their corresponding PostgreSQL type.\r\n\r\nFor more information, see the [JSON path documentation](https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-OP-TABLE)","name":"SQL/JSON: datetime()","versions":{"13":"Yes"}},"group":"JSON","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"11","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"12","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"13","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},{"Version":"14","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},{"Version":"8.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.0","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.5","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.6","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"}],"Texts":[{"Locale":"en","Title":"SQL/JSON: datetime()","BodyHTML":"\u003cp\u003eThe SQL/JSON path \u003ccode\u003edatetime()\u003c/code\u003e function in JSON path expressions converts valid date and time formats (e.g. ISO 8601) to their corresponding PostgreSQL type.\u003c/p\u003e\n\u003cp\u003eFor more information, see the \u003ca href=\"https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-OP-TABLE\" rel=\"nofollow\"\u003eJSON path documentation\u003c/a\u003e\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"9b36465993a0dc766b9f8f597482042813d2ac4616eaf46a9617b401b0eb0a63","Payload":{"description":"The SQL/JSON path `datetime()` function in JSON path expressions converts valid date and time formats (e.g. ISO 8601) to their corresponding PostgreSQL type.\r\n\r\nFor more information, see the [JSON path documentation](https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-OP-TABLE)","name":"SQL/JSON: datetime()","versions":{"13":"Yes"}}},{"Locale":"zh-Hans","Title":"SQL/JSON: datetime()","BodyHTML":"\u003cp\u003eSQL/JSON 路径 \u003ccode\u003edatetime()\u003c/code\u003e 函数在 JSON 路径表达式中将有效的日期和时间格式（例如 ISO 8601）转换为对应的 PostgreSQL 类型。\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-OP-TABLE\" rel=\"nofollow\"\u003eJSON 路径文档\u003c/a\u003e\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"c221ea3329833f4050731abcc6ead5577ae29743c40df4c2790f33bab1c378da","Payload":{"description":"SQL/JSON 路径 `datetime()` 函数在 JSON 路径表达式中将有效的日期和时间格式（例如 ISO 8601）转换为对应的 PostgreSQL 类型。\n\n更多信息请参阅 [JSON 路径文档](https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-OP-TABLE)","name":"SQL/JSON: datetime()"}}],"GroupTitles":{"en":"JSON","zh-Hans":"JSON"},"LegacyIDs":["346"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"13","Supported":true,"Original":"Yes"},"selected_version":"18"}