Purpose
The AsJSONText method returns the text representation of the specified JSON instance.
Syntax
Syntax Elements
- JSON_expr
- An expression that evaluates to a JSON data type.
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.