Date and time functions
Millennium, Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond
Conversion functions
SN
Math functions
Abs, ACos, ASin, ATan, ATan2, Cbrt, Ceiling, Checksum, Cos, Cot, Degrees, DExp, DLog1, DLog10, Exp, Floor, Ln, Log, Mod, Pi, Power, Radians, Random, Round, Sin, Sign, Sqrt, Tan, Trunc
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Min, Max, First, Last, Count, UniqueCount, Stddev_Pop, Stddev_Samp, Var_Pop, Var_Samp
Text functions
Concat, Initcap, LeftStr, Length, Lower, LTrim, Md5, RightStr, RTrim, Repeat, Replace, Reverse, Strpos, Trim, Upper, Char_Length, BTrim, Chr, To_Hex, Translate
Binning
Binning is not supported.
See also: