JSONGETVALUE ( jsonObject, jsonPath AS data_type )
Syntax Elements
- jsonObject
- Any JSON type object, including storage formats BSON and UBJSON.
- jsonPath
- The path to the value being extracted.
- data_type
-
One of the following supported data types:
- BYTEINT
- SMALLINT
- INT
- BIGINT
- FLOAT
- DECIMAL
- NUMBER
- VARCHAR (LATIN or UNICODE)
- CHAR (LATIN or UNICODE)
- DATE
- TIME (with zone)
- TIMESTAMP (with zone)
- All INTERVAL types