The ODBC driver supports the following functions which can be called either with the ODBC <scalar function extension> or without it. For the syntax of the ODBC <scalar function extension>, see the SQL Grammar in the CALL Interface (ODBC) manual.
Numeric functions: ABS, ACOS, ASIN, ATAN, ATAN2, COS, COT, TAN, SIN, CEILING, FLOOR, EXP, LOG, MOD, SIGN, SQRT, PI
String functions: LEFT, RIGHT, LENGTH, RTRIM, LTRIM, SUBSTRING, REPLACE, UCASE, LCASE
System functions: USERNAME, DBNAME, IFNULL
Time-Date functions: CURDATE, CURTIME, DAYOFYEAR, DAYOFMONTH, DAYOFWEEK,
YEAR, MONTH, WEEK, HOUR, MINUTE, SECOND
NOW