Date and Time functions
Year, Quarter, Month, Week, WeekDay, WeekOfYear, Day, DayOfMonth, DayOfYear, DayOfWeek, DayName, Hour, Minute, Second, Microsecond
Conversion functions
SN
Math functions
Abs, ASin, ACos, ATan, Ceiling, Cos, Sin, Tan, Cot, Exp, Floor, Log, Log10, Log2, Ln, Power, Sqrt, Degrees, Pi, Truncate
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, Std, Stddev_Samp, Var_Samp, Var_Pop
Text functions
Concat, Instr, Length, Lower, LPad, RPad, RTrim, Trim, Upper, LeftString, RightString, Locate, Space, Replace, Substring, Substring_Index, Soundex, Reverse, Format, Insert
See also: