15.10 - AsJSONText - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

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.
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.