JSONGETVALUE

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

Purpose

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.

Syntax



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