Supported scalar functions

You can use scalar functions in SQL statements with the following syntax:

{fn scalar-function}

where:

scalar-function

is a scalar function supported by the driver, as listed in the following table.

Example:

SELECT id, name FROM emp WHERE name LIKE {fn UCASE('Smith')}

Table 1. Supported Scalar Functions

String Functions	Numeric Functions	Timedate Functions	System Functions
ASCII CHAR CONCAT LCASE LOCATE LTRIM REPEAT REPLACE RIGHT RTRIM SUBSTRING UCASE CHAR_LENGTH INSTR LEN LOWER MAX MIN POSITION REGEXP REMOVEACCENTS REPLACEMAP SPLIT TEXTCONSTANT TRIM UPPER	ABS ACOS ASIN ATAN ATAN2 COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POWER RADIANS ROUND SIGN SIN SQRT TAN TRUNCATE CEIL DIV LN MAX MIN MULT SUBTRACT SUM	CURRENT_DATE DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT MONTH MONTHNAME NOW QUARTER WEEK YEAR ADDDAY ADDHOUR ADDMINUTE ADDMONTH ADDSECOND ADDWEEK ADDYEAR FIRSTDAYOFMONTH FIRSTDAYOFWEEK FORMATDATE GETDAY GETDAYOFWEEK GETDAYOFYEAR GETDAYSBETWEEN GETHOUR GETMILLISECOND GETMINUTE GETMONTH GETMONTHSBETWEEN GETQUARTER GETSECOND GETTIMEINMILLIS GETWEEK GETYEAR LASTDAYOFMONTH LASTDAYOFWEEK MAX MIN NEXTWEEKDAY PREVIOUSWEEKDAY SUBTRACT TO_DATE TRUNC	IFNULL GETSESSION NULLIF ROWNUM