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
Other functionality
Stored procedures
In connections to MemSQL databases, stored procedures are not supported.
Note: Stored procedures that do not result in a data table output will not be visible in the Views in Connection dialog for some connectors. The schema of the stored procedure must not change from time to time (for example, the use of parameters must not change the schema).