Built-in functions

Built-in Functions

This article provides an alphabetical list of built-in functions shared by the different dialects.

ANSI SQL	Snowflake
ABS	ABS
ACOS	ACOS
ACOSH	ACOSH
ANY_VALUE	ANY_VALUE
APPROX_COUNT_DISTINCT	APPROX_COUNT_DISTINCT
ARRAY	ARRAY_CONSTRUCT
ASCII	ASCII
ASIN	ASIN
ASINH	ASINH
ATAN	ATAN
ATAN2	ATAN2
ATANH	ATANH
ATN2	ATAN2
AVE	AVG
AVERAGE	AVG
AVG	AVG
BTRIM	TRIM
CBRT	CBRT
CEIL	CEIL
CEILING	CEIL
CHARACTER_LENGTH	LENGTH
CHARINDEX	CHARINDEX
CHAR_LENGTH	LENGTH
CHR	CHR
COALESCE	COALESCE
CONCAT	CONCAT
CORR	CORR
COS	COS
COSH	COSH
COT	COT
COUNT	COUNT
COVAR_POP	COVAR_POP
COVAR_SAMP	COVAR_SAMP
CUME_DIST	CUME_DIST
CURDATE	CURRENT_DATE
CURRENT_DATABASE	CURRENT_DATABASE
CURRENT_DATE	CURRENT_DATE
CURRENT_SCHEMA	CURRENT_SCHEMA
CURRENT_TIMESTAMP	CURRENT_TIMESTAMP
CURRENT_USER	CURRENT_USER
DATE	DATE
DECODE	DECODE
DEGREES	DEGREES
DENSE_RANK	DENSE_RANK
EXP	EXP
FIRST_VALUE	FIRST_VALUE
FLOOR	FLOOR
GREATEST	GREATEST
GROUPING	GROUPING
IF	IFF
IFF	IFF
IFNULL	IFNULL
IIF	IFF
INITCAP	INITCAP
KURTOSIS	KURTOSIS
LAG	LAG
LAST_DAY	LAST_DAY
LAST_VALUE	LAST_VALUE
LEAD	LEAD
LEAST	LEAST
LEFT	LEFT
LEN	LEN
LENGTH	LENGTH
LN	LN
LOG	LOG
LOWER	LOWER
LPAD	LPAD
LTRIM	LTRIM
MAX	MAX
MAXIMUM	MAX
MEDIAN	MEDIAN
MIN	MIN
MINIMUM	MIN
MOD	MOD
NOW	CURRENT_TIMESTAMP
NTH_VALUE	NTH_VALUE
NTILE	NTILE
NULLIF	NULLIF
NULLIFZERO	NULLIFZERO
NVL	NVL
NVL2	NVL2
OCTET_LENGTH	OCTET_LENGTH
PERCENTILE_CONT	PERCENTILE_CONT
PERCENTILE_DISC	PERCENTILE_DISC
PERCENT_RANK	PERCENT_RANK
PI	PI
POSITION	POSITION
POW	POW
POWER	POWER
RADIANS	RADIANS
RANDOM	RANDOM
RANK	RANK
REGEXP_COUNT	REGEXP_COUNT
REGEXP_SUBSTR	REGEXP_SUBSTR
REGR_AVGX	REGR_AVGX
REGR_AVGY	REGR_AVGY
REGR_COUNT	REGR_COUNT
REGR_INTERCEPT	REGR_INTERCEPT
REGR_SLOPE	REGR_SLOPE
REGR_SXX	REGR_SXX
REGR_SXY	REGR_SXY
REGR_SYY	REGR_SYY
REPEAT	REPEAT
REPLACE	REPLACE
REPLICATE	REPLACE
RIGHT	RIGHT
ROLLUP	ROLLUP
ROUND	ROUND
ROW_NUMBER	ROW_NUMBER
RPAD	RPAD
RTRIM	RTRIM
SHA1	SHA1
SHA2	SHA2
SIGN	SIGN
SIN	SIN
SOUNDEX	SOUNDEX
SPACE	SPACE
SPLIT_PART	SPLIT_PART
SQRT	SQRT
STDDEV_POP	STDDEV_POP
STDDEV_SAMP	STDDEV_SAMP
STDDEV	STDDEV
SUBSTR	SUBSTR
SUBSTRING	SUBSTRING
SUM	SUM
TAN	TAN
TANH	TANH
TIMESTAMP	TO_TIMESTAMP
TO_TIMESTAMP	TO_TIMESTAMP
TRANSLATE	TRANSLATE
TRIM	TRIM
UCASE	UPPER
UPPER	UPPER
USER	CURRENT_USER
VAR_POP	VAR_POP
VAR_SAMP	VAR_SAMP
VARIANCE_POP	VARIANCE_POP
VARIANCE_SAMP	VARIANCE_SAMP
VARIANCE	VARIANCE
VARP	VAR_POP
WIDTH_BUCKET	WIDTH_BUCKET
ZEROIFNULL	ZEROIFNULL