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

ACOS

ACOSH

ANY_VALUE

APPROX_COUNT_DISTINCT

ASCII

ASIN

ASINH

ATAN

ATAN2

ATANH

ATN2

AVE

AVERAGE

AVG

BTRIM

CBRT

CEIL

CEILING

CHARACTER_LENGTH

CHARINDEX

CHAR_LENGTH

CHR

COALESCE

CONCAT

CORR

COS

COSH

COT

COUNT

COVAR_POP

COVAR_SAMP

CUME_DIST

CURRENT_DATABASE

CURRENT_DATE

CURRENT_SCHEMA

CURRENT_TIMESTAMP

CURRENT_USER

DATE

DECODE

DEGREES

DENSE_RANK

EXP

FIRST_VALUE

FLOOR

GREATEST

GROUPING

IF

IFF

IFNULL

IIF

INITCAP

KURTOSIS

LAG

LAST_DAY

LAST_VALUE

LEAD

LEAST

LEFT

LEN

LENGTH

LN

LOG

LOWER

LPAD

LTRIM

MAX

MAXIMUM

MEDIAN

MIN

MINIMUM

MOD

NTH_VALUE

NTILE

NULLIF

NULLIFZERO

NVL

NVL2

OCTET_LENGTH

PERCENTILE_CONT

PERCENTILE_DISC

PERCENT_RANK

PI

POSITION

POW

POWER

RADIANS

RANDOM

RANK

REGEXP_COUNT

REGEXP_SUBSTR

REGR_AVGX

REGR_AVGY

REGR_COUNT

REGR_INTERCEPT

REGR_SLOPE

REGR_SXX

REGR_SXY

REGR_SYY

REPEAT

REPLACE

REPLICATE

RIGHT

ROLLUP

ROUND

ROW_NUMBER

RPAD

RTRIM

SHA1

SHA2

SIGN

SIN

SOUNDEX

SPACE

SPLIT_PART

SQRT

STDDEV_POP

STDDEV_SAMP

STDDEV

SUBSTR

SUBSTRING

SUM

TAN

TANH

TIMESTAMP

TO_TIMESTAMP

TRANSLATE

TRIM

UCASE

UPPER

VAR_POP

VAR_SAMP

VARIANCE_POP

VARIANCE_SAMP

VARIANCE

WIDTH_BUCKET

ZEROIFNULL

Last updated