Conversion Functions

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