The AsJSONText method returns the text representation of the specified JSON instance.
- An expression that evaluates to a JSON data type.
- The JSON data can be stored in any of the supported storage formats.
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.
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.