AsJSONText - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ JSON Data Type

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

Purpose

The AsJSONText method returns the text representation of the specified JSON instance.

Syntax



JSON_expr
An expression that evaluates to a JSON data type.
The JSON data can be stored in any of the supported storage formats.

Return Value

A CLOB value representing the input JSON data in text format. The character set of the return value is UNICODE.

A Teradata NULL is returned if the JSON_expr argument is NULL.

Usage Notes

You can use the AsJSONText method to get the JSON text representation of JSON data that is stored in a binary format such as BSON or UBJSON.

If the input JSON data is already stored as text, this method merely returns the data passed into it.