SQL/JSON: datetime()
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
No translation of this description is recorded. The original Chinese description is shown.
数据类型、函数和运算符
Description
SQL/JSON 路径 datetime() 函数在 JSON 路径表达式中将有效的日期和时间格式（例如 ISO 8601）转换为对应的 PostgreSQL 类型。
更多信息请参阅 JSON 路径文档
Selected version: PostgreSQL 18
No
Compare versions
Original documentation links
Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.
Complete source facts and provenance
legacy · center · 150f0f519aa80216b643d8118f82c59cc7545b187fa3fda43a7e5772c6e75b67
{
"Key": "346",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "346",
"SourceHash": "150f0f519aa80216b643d8118f82c59cc7545b187fa3fda43a7e5772c6e75b67",
"Name": "SQL/JSON: datetime()",
"NameLocale": "en",
"GroupKey": "9",
"GroupName": "数据类型、函数和运算符",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 2,
"Facts": {
"featuredescription": "SQL/JSON 路径 `datetime()` 函数在 JSON 路径表达式中将有效的日期和时间格式（例如 ISO 8601）转换为对应的 PostgreSQL 类型。\n\n更多信息请参阅 [JSON 路径文档](https://www.postgresql.org/docs/13/functions-json.html#FUNCTIONS-SQLJSON-OP-TABLE)",
"featurename": "SQL/JSON: datetime()",
"group_id": 9,
"id": 346,
"v10": 0,
"v11": 0,
"v12": 0,
"v13": 1,
"v14": 0,
"v15": 0,
"v16": 0,
"v17": 0,
"v18": 0,
"v74": 0,
"v80": 0,
"v81": 0,
"v82": 0,
"v83": 0,
"v84": 0,
"v90": 0,
"v91": 0,
"v92": 0,
"v93": 0,
"v94": 0,
"v95": 0,
"v96": 0
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "legacy-database:v10",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "legacy-database:v11",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "legacy-database:v12",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "legacy-database:v13",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "legacy-database:v14",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "legacy-database:v15",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "legacy-database:v16",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "17",
"State": "no",
"EvidenceKind": "legacy-database:v17",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "18",
"State": "no",
"EvidenceKind": "legacy-database:v18",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "7.4",
"State": "no",
"EvidenceKind": "legacy-database:v74",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.0",
"State": "no",
"EvidenceKind": "legacy-database:v80",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "legacy-database:v81",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "legacy-database:v82",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "legacy-database:v83",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "legacy-database:v84",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "legacy-database:v90",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "legacy-database:v91",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "legacy-database:v92",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "legacy-database:v93",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "legacy-database:v95",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "legacy-database:v96",
"TransitionVersion": "",
"Supported": false,
"Original": 0
}
],
"Texts": [
{
"Locale": "en",
"Title": "SQL/JSON: datetime()",
"BodyHTML": "",
"SourceHash": "150f0f519aa80216b643d8118f82c59cc7545b187fa3fda43a7e5772c6e75b67",
"ContentHash": "fc834f9f1d0b393fb96266bd1c595f5b8b67ff81dbb70856725e2b6766d5aa07",
"Payload": {
"name": "SQL/JSON: datetime()"
}
},
{
"Locale": "zh-Hans",
"Title": "",
"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": "150f0f519aa80216b643d8118f82c59cc7545b187fa3fda43a7e5772c6e75b67",
"ContentHash": "dbdf9a374df54927a956e7876af41ce4fa88e56e90c5a1f77dd7eb2002c1d969",
"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)"
}
}
],
"GroupTitles": {
"zh-Hans": "数据类型、函数和运算符"
},
"RelatedKey": "sqljson-datetime"
}