Date and Time functions
YEAR, QUARTER, MONTH, WEEK, WEEKOFYEAR, WEEKOFMONTH, DAY, DAYOFWEEK, DAYOFMONTH, DAYOFYEAR, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND
Conversion functions
SN
Math functions
ABS, ACOS, ASIN, ATAN, CBRT, CEILING, COS, COT, DEGREES, EXP, FLOOR, LN, LOG, MOD, PI, POWER, RADIANS, RANDOM, ROUND, SIGN, SIN, SQRT, TAN, TRUNC
Operators
%, -, +, *, /
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT, VARIANCE, VAR_POP, VAR_SAMP, STDDEV, STDDEV_POP, STDDEV_SAMP
Text functions
CONCAT, INITCAP, LENGTH, LOWER, LPAD, LTRIM, MD5, RPAD, REPEAT, REPLACE, RTRIM, STRPOS, SUBSTR, TRIM, UPPER
Other supported functionality
Binning
Stored procedures