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
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
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
Supported Signatures
function cot(float) returns float
๐ Official Documentation
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
Supported Signatures
function dexp(float) returns float
๐ Official Documentation
difference
Supported Signatures
function difference(varchar, varchar) returns bigint
๐ Official Documentation
Supported Signatures
function dlog1(float) returns float
๐ Official Documentation
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
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
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
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
Supported Signatures
function least($1, ...) returns $1
๐ Official Documentation
Supported Signatures
function len(varchar) returns bigint
๐ Official Documentation
Supported Signatures
function md5(varchar) returns bigint
๐ Official Documentation
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
Supported Signatures
function nvl($1, ...) returns $1
๐ Official Documentation
Supported Signatures
function nvl2($1, $2, $2) returns $2
๐ Official Documentation
octetindex
Supported Signatures
function octetindex(varchar, varchar) returns bigint
๐ Official Documentation
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:
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
Supported Signatures
function sha(varchar) returns bigint
๐ Official Documentation
Supported Signatures
function sha1(varchar) returns bigint
๐ Official Documentation
Supported Signatures
function sha2(varchar, bigint) returns bigint
๐ Official Documentation
Supported Signatures
function sign(float) returns bigint
๐ Official Documentation
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
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
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
Supported Signatures
function trunc(varchar) returns date
๐ Official Documentation