Date and Time functions
Day, DayName, DayOfWeek, DayOfYear, Hour, Microsecond, Minute, Month, MonthName, Month_Between, Next_Day, Quarter, Second, Week, WeekOfYear, Year, DayOfMonth, Millisecond, SecondOfDay, WeekOfMonth
Conversion functions
SN
Math functions
Abs, Ceiling, Degress, Exp, Floor, Ln, Log10, Max, Min, Mod, Power, Radians, Rand, Round, Sign, Sqrt, Trunc, Acos, Asin, Atan, Atan2, Atanh, Cos, Cosh, Cot, Sin, Sinh, Tan, Tanh
Operators
%, -, +, *, /
Statistical functions
Avg, Count, UniqueCount, Count_Big, Min, Max, Stddev, Sum, Variance
Text functions
Concat, Initcap, Insert, Instr, Lcase, LeftStr, Length, Lower, Lpad, Ltrim, Overlay, Position, PosStr, Repeat, Replace, RightStr, Rpad, Rtrim, Soundex, Space, SubStr, Trim, Ucase, Upper
Binning is not supported by this connector.
See also: