SnowConvert AI - ANSI SQL - 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 |