add_months

Supported Signatures
function add_months(varchar, bigint) returns timestamp
🔗 Official Documentation

any_value

Supported Signatures
function any_value($1) returns $1
🔗 Official Documentation

array

Supported Signatures
function array($1, ...) returns super
🔗 Official Documentation

array_flatten

Supported Signatures
function array_flatten(super) returns super
🔗 Official Documentation

bpcharcmp

Supported Signatures
function bpcharcmp(varchar, varchar) returns bigint
🔗 Official Documentation

bttext_pattern_cmp

Supported Signatures
function bttext_pattern_cmp(varchar, varchar) returns bigint
🔗 Official Documentation

can_json_parse

Supported Signatures
function can_json_parse(varchar) returns boolean
🔗 Official Documentation

cbrt

Supported Signatures
function cbrt(float) returns float
🔗 Official Documentation

ceiling

Supported Signatures
function ceiling(float) returns float
🔗 Official Documentation

charindex

Supported Signatures
function charindex(varchar, varchar) returns bigint
🔗 Official Documentation

collate

Supported Signatures
function collate(varchar, varchar) returns varchar
🔗 Official Documentation

cot

Supported Signatures
function cot(float) returns float
🔗 Official Documentation

crc32

Supported Signatures
function crc32(varchar) returns varchar
🔗 Official Documentation

decimal_precision

Supported Signatures
function decimal_precision(super) returns bigint
🔗 Official Documentation

decimal_scale

Supported Signatures
function decimal_scale(super) returns bigint
🔗 Official Documentation

degrees

Supported Signatures
function degrees(float) returns float
🔗 Official Documentation

dexp

Supported Signatures
function dexp(float) returns float
🔗 Official Documentation

difference

Supported Signatures
function difference(varchar, varchar) returns bigint
🔗 Official Documentation

dlog1

Supported Signatures
function dlog1(float) returns float
🔗 Official Documentation

dlog10

Supported Signatures
function dlog10(float) returns float
🔗 Official Documentation

farmfingerprint64

Supported Signatures
function farmfingerprint64(varchar) returns bigint
🔗 Official Documentation

fnv_hash

Supported Signatures
function fnv_hash(varchar) returns bigint
🔗 Official Documentation

from_hex

Supported Signatures
function from_hex(varchar) returns varbyte
🔗 Official Documentation

from_varbyte

Supported Signatures
function from_varbyte(varbyte, varchar) returns varbyte
🔗 Official Documentation

func_sha1

Supported Signatures
function func_sha1(varchar) returns bigint
🔗 Official Documentation

getbit

Supported Signatures
function getbit(varbyte, bigint) returns bigint
🔗 Official Documentation

greatest

Supported Signatures
function greatest($1, ...) returns $1
🔗 Official Documentation

interval_cmp

Supported Signatures
function interval_cmp(varchar, varchar) returns bigint
🔗 Official Documentation

is_array

Supported Signatures
function is_array(super) returns boolean
🔗 Official Documentation

is_bigint

Supported Signatures
function is_bigint(super) returns boolean
🔗 Official Documentation

is_boolean

Supported Signatures
function is_boolean(super) returns boolean
🔗 Official Documentation

is_char

Supported Signatures
function is_char(super) returns boolean
🔗 Official Documentation

is_decimal

Supported Signatures
function is_decimal(super) returns boolean
🔗 Official Documentation

is_float

Supported Signatures
function is_float(super) returns boolean
🔗 Official Documentation

is_object

Supported Signatures
function is_object(super) returns boolean
🔗 Official Documentation

is_scalar

Supported Signatures
function is_scalar(super) returns boolean
🔗 Official Documentation

is_smallint

Supported Signatures
function is_smallint(super) returns boolean
🔗 Official Documentation

is_valid_json

Supported Signatures
function is_valid_json(varchar) returns boolean
🔗 Official Documentation

is_valid_json_array

Supported Signatures
function is_valid_json_array(varchar) returns boolean
🔗 Official Documentation

is_varchar

Supported Signatures
function is_varchar(super) returns boolean
🔗 Official Documentation

json_extract_array_element_text

Supported Signatures
function json_extract_array_element_text(varchar, bigint) returns varchar
function json_extract_array_element_text(varchar, bigint, boolean) returns varchar
🔗 Official Documentation

json_extract_path_text

Supported Signatures
function json_extract_path_text(varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, varchar, boolean) returns varchar
🔗 Official Documentation

json_parse

Supported Signatures
function json_parse(varchar) returns super
🔗 Official Documentation

json_serialize

Supported Signatures
function json_serialize($1) returns varchar
🔗 Official Documentation

json_serialize_to_varbyte

Supported Signatures
function json_serialize_to_varbyte($1) returns varbyte
🔗 Official Documentation

json_size

Supported Signatures
function json_size(super) returns bigint
🔗 Official Documentation

json_typeof

Supported Signatures
function json_typeof(super) returns varchar
🔗 Official Documentation

last_day

Supported Signatures
function last_day(varchar) returns date
🔗 Official Documentation

least

Supported Signatures
function least($1, ...) returns $1
🔗 Official Documentation

len

Supported Signatures
function len(varchar) returns bigint
🔗 Official Documentation

md5

Supported Signatures
function md5(varchar) returns bigint
🔗 Official Documentation

mod

Supported Signatures
function mod(bigint, bigint) returns bigint
🔗 Official Documentation

months_between

Supported Signatures
function months_between(varchar, varchar) returns float
🔗 Official Documentation

murmur3_32_hash

Supported Signatures
function murmur3_32_hash(varchar) returns bigint
function murmur3_32_hash(varchar, bigint) returns bigint
🔗 Official Documentation

next_day

Supported Signatures
function next_day(varchar, varchar) returns date
🔗 Official Documentation

nvl

Supported Signatures
function nvl($1, ...) returns $1
🔗 Official Documentation

nvl2

Supported Signatures
function nvl2($1, $2, $2) returns $2
🔗 Official Documentation

octetindex

Supported Signatures
function octetindex(varchar, varchar) returns bigint
🔗 Official Documentation

pi

Supported Signatures
function pi() returns float
🔗 Official Documentation

quote_ident

Supported Signatures
function quote_ident(varchar) returns varchar
🔗 Official Documentation

quote_literal

Supported Signatures
function quote_literal(varchar) returns varchar
🔗 Official Documentation

radians

Supported Signatures
function radians(float) returns float
🔗 Official Documentation

reclassify

Changes the classification label of the first argument from the expected classifier specified by the second argument to the desired classifier specified by the third. The expected and desired classifiers must belong to the same classifier group. No other classifiers attached to the first argument are impacted. The function will emit a warning if the the first argument does not have the expected classifier Examples:
examples.sql
select reclassify(12345, 'pii.clear_text', 'pii.masked') as value; -- value '12345'
Supported Signatures
function reclassify($1, varchar, varchar) returns $1
🔗 Official Documentation

regexp_instr

Supported Signatures
function regexp_instr(varchar, varchar) returns bigint
function regexp_instr(varchar, varchar, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint, bigint, varchar) returns bigint
🔗 Official Documentation

regexp_substr

Supported Signatures
function regexp_substr(varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, varchar, bigint) returns varchar
function regexp_substr(varchar, varchar, varchar, bigint, varchar) returns varchar
🔗 Official Documentation

replicate

Supported Signatures
function replicate(varchar, bigint) returns varchar
🔗 Official Documentation

sha

Supported Signatures
function sha(varchar) returns bigint
🔗 Official Documentation

sha1

Supported Signatures
function sha1(varchar) returns bigint
🔗 Official Documentation

sha2

Supported Signatures
function sha2(varchar, bigint) returns bigint
🔗 Official Documentation

sign

Supported Signatures
function sign(float) returns bigint
🔗 Official Documentation

size

Supported Signatures
function size($1) returns bigint
🔗 Official Documentation

soundex

Supported Signatures
function soundex(varchar) returns varchar
🔗 Official Documentation

split_to_array

Supported Signatures
function split_to_array(varchar, varchar) returns super
🔗 Official Documentation

strtol

Supported Signatures
function strtol(varchar, bigint) returns bigint
🔗 Official Documentation

subarray

Supported Signatures
function subarray(super, bigint, bigint) returns super
🔗 Official Documentation

text_to_int_alt

Supported Signatures
function text_to_int_alt(varchar) returns bigint
function text_to_int_alt(varchar, varchar) returns bigint
🔗 Official Documentation

text_to_numeric_alt

Supported Signatures
function text_to_numeric_alt(varchar) returns float
function text_to_numeric_alt(varchar, varchar) returns float
function text_to_numeric_alt(varchar, bigint, bigint) returns float
function text_to_numeric_alt(varchar, varchar, bigint, bigint) returns float
🔗 Official Documentation

textlen

Supported Signatures
function textlen(varchar) returns bigint
🔗 Official Documentation

to_char

Supported Signatures
function to_char($1, varchar) returns varchar
🔗 Official Documentation

to_hex

Supported Signatures
function to_hex(varbyte) returns varchar
function to_hex(bigint) returns varchar
🔗 Official Documentation

to_number

Supported Signatures
function to_number(varchar, varchar) returns float
🔗 Official Documentation

to_varbyte

Supported Signatures
function to_varbyte(varchar, varchar) returns varbyte
🔗 Official Documentation

trunc

Supported Signatures
function trunc(varchar) returns date
🔗 Official Documentation