Date and Time functions
YEAR, QUARTER, MONTH, MONTHNAME, WEEK, DAYOFWEEK, DAYOFYEAR, DAYOFMONTH, DAYNAME, HOUR, MINUTE, SECOND, MILLISECOND, NOW, ADD_DAYS, ADD_MONTHS, ADD_SECONDS, ADD_YEARS, ISOWEEK, NEXT_DAY, LAST_DAY, DAYS_BETWEEN, SECONDS_BETWEEN, LOCALTOUTC, UTCTOLOCAL
Conversion functions
SN
Math functions
ABS, ACOS, ASIN, ATAN, ATAN2, BITAND, CEIL, COS, COSH, COT, EXP , FLOOR, LN, LOG, MOD, POWER, ROUND, SIGN, SIN, SINH, SQRT, TAN, TANH, UMINUS
Operators
%, -, +, *, /
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT, STDDEV, VAR
Text functions
ASCII, CHAR, CONCAT, LCASE, UCASE, LOWER, UPPER, LEFT, RIGHT, LENGTH, LOCATE, LPAD, RPAD, LTRIM, RTRIM, NCHAR, REPLACE, SUBSTR_AFTER, SUBSTR_BEFORE, SUBSTRING, UNICODE
Non-supported functions
Math functions:
GREATEST, LEAST, HEXTOBIN, BINTOHEX.
Date and Time functions:
CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_UTCDATE, CURRENT_UTCTIME, CURRENT_UTCTIMESTAMP, EXTRACT
Binning is not supported by this connector.
See also: