Extracts a value from a JSON object as a specific type. The user specifies the data type and the function returns a NULL if the conversion to that data type fails.
- Any JSON type object, including storage formats BSON and UBJSON.
- The path to the value being extracted.
One of the following supported data types:
- VARCHAR (LATIN or UNICODE)
- CHAR (LATIN or UNICODE)
- TIME (with zone)
- TIMESTAMP (with zone)
- All INTERVAL types