Type functions

View as MarkdownOpen in Claude

Type functions perform type casting or type conversion operations that transform values from one data type to another.

FunctionDescription
DateConverts text or number values to the date data type in ISO datetime format.
JSONConverts values to the variant data type in JSON format.
LogicalConverts values to the logical data type in boolean format (true or false).
NumberConverts values to the number data type.
TextConverts values to the text data type.
VariantConverts text values to the variant data type.

The following geography function also transform values from one data type to another:

GeographyConverts GeoJSON or WKT formats to the geography data type.