Snowflake Functions
Conversion Functions
Snowflake Functions
Conversion Functions
date
Converts the timestamp argument to a date Supported Signatures
function date(timestamp) returns date
function date(timestamp) returns date
function date(timestamp) returns date
function date(varchar) returns date
function date(varchar, varchar) returns date
time
Converts the timestamp argument to a time Supported Signatures
function time(timestamp) returns time
function time(timestamp) returns time
function time(timestamp) returns time
function time(varchar) returns time
function time(variant) returns time
to_array
Supported Signatures
function to_array($1) returns array
to_binary
Supported Signatures
function to_binary($1) returns binary
function to_binary($1, string) returns binary
to_boolean
Supported Signatures
function to_boolean($1) returns boolean
to_char
Supported Signatures
function to_char($1, string) returns string
function to_char($1) returns string
to_date
Supported Signatures
function to_date($1) returns datetime
function to_date($1, string) returns datetime
to_decimal
Supported Signatures
function to_decimal($1) returns decimal(38, 0)
function to_decimal($1, bigint) returns decimal(38, 0)
function to_decimal($1, bigint, bigint) returns decimal(38, 0)
function to_decimal($1, string) returns decimal(38, 0)
function to_decimal($1, string, bigint) returns decimal(38, 0)
function to_decimal($1, string, bigint, bigint) returns decimal(38, 0)
to_double
Supported Signatures
function to_double($1) returns double
to_json
Convert variant data to string as JSON Supported Signatures
function to_json(variant) returns varchar
to_number
Supported Signatures
function to_number($1) returns decimal(38, 0)
function to_number($1, bigint) returns decimal(38, 0)
function to_number($1, bigint, bigint) returns decimal(38, 0)
function to_number($1, string) returns decimal(38, 0)
function to_number($1, string, bigint) returns decimal(38, 0)
function to_number($1, string, bigint, bigint) returns decimal(38, 0)
to_numeric
Supported Signatures
function to_numeric($1) returns decimal(38, 0)
function to_numeric($1, bigint) returns decimal(38, 0)
function to_numeric($1, bigint, bigint) returns decimal(38, 0)
function to_numeric($1, string) returns decimal(38, 0)
function to_numeric($1, string, bigint) returns decimal(38, 0)
function to_numeric($1, string, bigint, bigint) returns decimal(38, 0)
to_object
Supported Signatures
function to_object($1) returns object
to_time
Supported Signatures
function to_time($1) returns time
function to_time($1, string) returns time
to_timestamp
Supported Signatures
function to_timestamp($1) returns timestamp
function to_timestamp($1, string) returns timestamp
to_timestamp_ltz
Supported Signatures
function to_timestamp_ltz($1) returns timestamp
function to_timestamp_ltz($1, string) returns timestamp
to_timestamp_ntz
Supported Signatures
function to_timestamp_ntz($1) returns timestamp
function to_timestamp_ntz($1, string) returns timestamp
to_timestamp_tz
Supported Signatures
function to_timestamp_tz($1) returns timestamp
function to_timestamp_tz($1, string) returns timestamp
to_varchar
Supported Signatures
function to_varchar($1) returns string
function to_varchar($1, string) returns string
to_variant
Supported Signatures
function to_variant($1) returns variant
to_xml
Convert variant data to string as XML Supported Signatures
function to_xml(variant) returns varchar
try_to_binary
Supported Signatures
function try_to_binary($1) returns binary
function try_to_binary(string, string) returns binary
try_to_boolean
Supported Signatures
function try_to_boolean($1) returns boolean
try_to_date
Supported Signatures
function try_to_date($1) returns datetime
function try_to_date($1, string) returns datetime
try_to_decimal
Supported Signatures
function try_to_decimal($1) returns decimal(38, 0)
function try_to_decimal($1, bigint) returns decimal(38, 0)
function try_to_decimal($1, bigint, bigint) returns decimal(38, 0)
function try_to_decimal($1, string) returns decimal(38, 0)
function try_to_decimal($1, string, bigint) returns decimal(38, 0)
function try_to_decimal($1, string, bigint, bigint) returns decimal(38, 0)
try_to_double
Supported Signatures
function try_to_double($1) returns double
try_to_number
Supported Signatures
function try_to_number($1) returns decimal(38, 0)
function try_to_number($1, bigint) returns decimal(38, 0)
function try_to_number($1, bigint, bigint) returns decimal(38, 0)
function try_to_number($1, string) returns decimal(38, 0)
function try_to_number($1, string, bigint) returns decimal(38, 0)
function try_to_number($1, string, bigint, bigint) returns decimal(38, 0)
try_to_numeric
Supported Signatures
function try_to_numeric($1) returns decimal(38, 0)
function try_to_numeric($1, bigint) returns decimal(38, 0)
function try_to_numeric($1, bigint, bigint) returns decimal(38, 0)
function try_to_numeric($1, string) returns decimal(38, 0)
function try_to_numeric($1, string, bigint) returns decimal(38, 0)
function try_to_numeric($1, string, bigint, bigint) returns decimal(38, 0)
try_to_time
Supported Signatures
function try_to_time($1) returns time
function try_to_time($1, string) returns time
try_to_timestamp
Supported Signatures
function try_to_timestamp($1) returns timestamp
function try_to_timestamp($1, string) returns timestamp
try_to_timestamp_ntz
Supported Signatures
function try_to_timestamp_ntz($1) returns timestamp
function try_to_timestamp_ntz($1, string) returns timestamp
try_to_timestamp_tz
Supported Signatures
function try_to_timestamp_tz($1) returns timestamp
function try_to_timestamp_tz($1, string) returns timestamp