Conversion Functions

function date(timestamp) returns date
function date(varchar) returns date
function date(varchar, varchar) returns date

function time(timestamp) returns time
function time(varchar) returns time
function time(variant) returns time

function to_array($1) returns array

function to_binary($1) returns binary
function to_binary($1, string) returns binary

function to_boolean($1) returns boolean

function to_char($1, string) returns string
function to_char($1) returns string

function to_date($1) returns date
function to_date($1, string) returns date

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)

function to_double($1) returns double

function to_json(variant) returns varchar

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)

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)

function to_object($1) returns object

function to_time($1) returns time
function to_time($1, string) returns time

function to_timestamp($1) returns timestamp
function to_timestamp($1, string) returns timestamp

function to_timestamp_ltz($1) returns timestamp
function to_timestamp_ltz($1, string) returns timestamp

function to_timestamp_ntz($1) returns timestamp
function to_timestamp_ntz($1, string) returns timestamp

function to_timestamp_tz($1) returns timestamp
function to_timestamp_tz($1, string) returns timestamp

function to_varchar($1) returns string
function to_varchar($1, string) returns string

function to_variant($1) returns variant

function to_xml(variant) returns varchar

function try_to_binary($1) returns binary
function try_to_binary(string, string) returns binary

function try_to_boolean($1) returns boolean

function try_to_date($1) returns date
function try_to_date($1, string) returns date

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)

function try_to_double($1) returns double

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)

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)

function try_to_time($1) returns time
function try_to_time($1, string) returns time

function try_to_timestamp($1) returns timestamp
function try_to_timestamp($1, string) returns timestamp

function try_to_timestamp_ntz($1) returns timestamp
function try_to_timestamp_ntz($1, string) returns timestamp

function try_to_timestamp_tz($1) returns timestamp
function try_to_timestamp_tz($1, string) returns timestamp