date
Converts the timestamp argument to a date
Supported Signatures
function date(timestamp) returns date
function date(varchar) returns date
function date(varchar, varchar) returns date
🔗 Official Documentation
time
Converts the timestamp argument to a time
Supported Signatures
function time(timestamp) returns time
function time(varchar) returns time
function time(variant) returns time
🔗 Official Documentation
to_array
Supported Signatures
function to_array($1) returns array
🔗 Official Documentation
to_binary
Supported Signatures
function to_binary($1) returns binary
function to_binary($1, string) returns binary
🔗 Official Documentation
to_boolean
Supported Signatures
function to_boolean($1) returns boolean
🔗 Official Documentation
to_char
Supported Signatures
function to_char($1, string) returns string
function to_char($1) returns string
🔗 Official Documentation
to_date
Supported Signatures
function to_date($1) returns date
function to_date($1, string) returns date
🔗 Official Documentation
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)
🔗 Official Documentation
to_double
Supported Signatures
function to_double($1) returns double
🔗 Official Documentation
to_json
Convert variant data to string as JSON
Supported Signatures
function to_json(variant) returns varchar
🔗 Official Documentation
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)
🔗 Official Documentation
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)
🔗 Official Documentation
to_object
Supported Signatures
function to_object($1) returns object
🔗 Official Documentation
to_time
Supported Signatures
function to_time($1) returns time
function to_time($1, string) returns time
🔗 Official Documentation
to_timestamp
Supported Signatures
function to_timestamp($1) returns timestamp
function to_timestamp($1, string) returns timestamp
🔗 Official Documentation
to_timestamp_ltz
Supported Signatures
function to_timestamp_ltz($1) returns timestamp
function to_timestamp_ltz($1, string) returns timestamp
🔗 Official Documentation
to_timestamp_ntz
Supported Signatures
function to_timestamp_ntz($1) returns timestamp
function to_timestamp_ntz($1, string) returns timestamp
🔗 Official Documentation
to_timestamp_tz
Supported Signatures
function to_timestamp_tz($1) returns timestamp
function to_timestamp_tz($1, string) returns timestamp
🔗 Official Documentation
to_varchar
Supported Signatures
function to_varchar($1) returns string
function to_varchar($1, string) returns string
🔗 Official Documentation
to_variant
Supported Signatures
function to_variant($1) returns variant
🔗 Official Documentation
to_xml
Convert variant data to string as XML
Supported Signatures
function to_xml(variant) returns varchar
🔗 Official Documentation
try_to_binary
Supported Signatures
function try_to_binary($1) returns binary
function try_to_binary(string, string) returns binary
🔗 Official Documentation
try_to_boolean
Supported Signatures
function try_to_boolean($1) returns boolean
🔗 Official Documentation
try_to_date
Supported Signatures
function try_to_date($1) returns date
function try_to_date($1, string) returns date
🔗 Official Documentation
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)
🔗 Official Documentation
try_to_double
Supported Signatures
function try_to_double($1) returns double
🔗 Official Documentation
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)
🔗 Official Documentation
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)
🔗 Official Documentation
try_to_time
Supported Signatures
function try_to_time($1) returns time
function try_to_time($1, string) returns time
🔗 Official Documentation
try_to_timestamp
Supported Signatures
function try_to_timestamp($1) returns timestamp
function try_to_timestamp($1, string) returns timestamp
🔗 Official Documentation
try_to_timestamp_ntz
Supported Signatures
function try_to_timestamp_ntz($1) returns timestamp
function try_to_timestamp_ntz($1, string) returns timestamp
🔗 Official Documentation
try_to_timestamp_tz
Supported Signatures
function try_to_timestamp_tz($1) returns timestamp
function try_to_timestamp_tz($1, string) returns timestamp
🔗 Official Documentation
