|
| Numerical built-in Functions / Stored Procedures
|
| Designer
| Parser
| Direct
|
|
| ABS(d)
|
| YES
| YES
| YES
|
|
| ACOS(d)
|
| YES
| YES
| YES
|
|
| ASIN(d)
|
| YES
| YES
| YES
|
|
| ATAN(d)
|
| YES
| YES
| YES
|
|
| ATAN2(a,b)
|
| YES
| YES
| YES
|
|
| BITAND(a,b)
|
| YES
| YES
| YES
|
|
| BITOR(a,b)
|
| YES
| YES
| YES
|
|
| CEILING(d)
|
| YES
| YES
| YES
|
|
| COS(d)
|
| YES
| YES
| YES
|
|
| COT(d)
|
| YES
| YES
| YES
|
|
| DEGREES(d)
|
| YES
| YES
| YES
|
|
| EXP(d)
|
| YES
| YES
| YES
|
|
| FLOOR(d)
|
| YES
| YES
| YES
|
|
| LOG(d)
|
| NO
| NO
| YES
|
|
| LOG10(d)
|
| YES
| YES
| YES
|
|
| MOD(a,b)
|
| YES
| YES
| YES
|
|
| PI()
|
| YES
| YES
| YES
|
|
| POWER(a,b)
|
| YES
| YES
| YES
|
|
| RADIANS(d)
|
| YES
| YES
| YES
|
|
| RAND()
|
| YES
| YES
| YES
|
|
| ROUND(a,b)
|
| YES
| YES
| YES
|
|
| ROUNDMAGIC(d)
|
| YES
| YES
| YES
|
|
| SIGN(d)
|
| YES
| YES
| YES
|
|
| SIN(d)
|
| YES
| YES
| YES
|
|
| SQRT(d)
|
| YES
| YES
| YES
|
|
| TAN(A)
|
| YES
| YES
| YES
|
|
| TRUNCATE(a,b)
|
| YES
| YES
| YES
|
|
|
|
|
|
|
|
|
|
|
| Designer
| Parser
| Direct
|
| Statistical Functions
|
|
| VAR_POP
|
|
|
|
|
|
| VAR_SAMP
|
|
|
|
|
|
| STDDEV_POP
|
|
|
|
|
|
| STDDEV_SAMP
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Designer
| Parser
| Direct
|
| String built-in Functions / Stored Procedures
|
|
| ASCII(s)
|
| YES
| YES
| YES
|
|
| BIT_LENGTH(str)
|
| YES
| YES
| YES
|
|
| CHAR(c)
|
| YES
| YES
| YES
|
|
| CHAR_LENGTH(str)
|
| YES
| YES
| YES
|
|
| CONCAT(str1,str2)
|
| YES
| YES
| YES
|
|
| DIFFERENCE(s1,s2)
|
| YES
| YES
| YES
|
|
| HEXTORAW(s1)
|
| YES
| YES
| YES
|
|
| INSERT(s,start,len,s2)
|
| YES
| YES
| YES
|
|
| LCASE(s)
|
| YES
| YES
| YES
|
|
| LEFT(s,count)
|
| YES
| YES
| YES
|
|
| LENGTH(s)
|
| YES
| YES
| YES
|
|
| LOCATE(search,s,[start])
|
| YES
| YES
| YES
|
|
| LTRIM(s)
|
| YES
| YES
| YES
|
|
| OCTET_LENGTH(str)
|
| YES
| YES
| YES
|
|
| RAWTOHEX(s1)
|
| YES
| YES
| YES
|
|
| POSITION (... IN ..)
|
| YES
| YES
| YES
|
|
| REPEAT(s,count)
|
| YES
| YES
| YES
|
|
| REPLACE(s,replace,s2)
|
| YES
| YES
| YES
|
|
| RIGHT(s,count)
|
| YES
| YES
| YES
|
|
| RTRIM(s)
|
| YES
| YES
| YES
|
|
| SOUNDEX(s)
|
| YES
| YES
| YES
|
|
| SPACE(count)
|
| YES
| YES
| YES
|
|
| SUBSTR(s,start[,len])
|
| YES
| YES
| YES
|
|
| SUBSTRING(s,start[,len])
|
| YES
| YES
| YES
|
|
| SUBSTRING(... FROM ... FOR ...)
|
| YES
| YES
| YES
|
|
| TRIM( [|LEADING| TRAILING| BOTH|] FROM <COLUMN> )
|
| NO
| YES
| YES
|
|
| UCASE(s)
|
| YES
| YES
| YES
|
|
| LOWER(s)
|
| YES
| YES
| YES
|
|
| UPPER(s)
|
| YES
| YES
| YES
|
|
|
|
|
|
|
|
|
|
|
| Designer
| Parser
| Direct
|
| Date/Time built-in Functions / Stored Procedures
|
|
| CURDATE()
|
| YES
| YES
| YES
|
|
| CURTIME()
|
| YES
| YES
| YES
|
|
| DATEDIFF(string, datetime1, datetime2)
|
| YES
| YES
| YES
|
|
| DAYNAME(date)
|
| YES
| YES
| YES
|
|
| DAYOFMONTH(date)
|
| YES
| YES
| YES
|
|
| DAYOFWEEK(date)
|
| YES
| YES
| YES
|
|
| DAYOFYEAR(date)
|
| YES
| YES
| YES
|
|
| HOUR(time)
|
| YES
| YES
| YES
|
|
| MINUTE(time)
|
| YES
| YES
| YES
|
|
| MONTH(date)
|
| YES
| YES
| YES
|
|
| MONTHNAME(date)
|
| YES
| YES
| YES
|
|
| NOW()
|
| YES
| YES
| YES
|
|
| QUARTER(date)
|
| YES
| YES
| YES
|
|
| SECOND(time)
|
| YES
| YES
| YES
|
|
| WEEK(date)
|
| YES
| YES
| YES
|
|
| YEAR(date)
|
| YES
| YES
| YES
|
|
| CURRENT_DATE
|
| YES
| YES
| YES
|
|
| CURRENT_TIME
|
| YES
| YES
| YES
|
|
| CURRENT_TIMESTAMP
|
| YES
| YES
| YES
|
|
| TO_CHAR( <date column>, format String )
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Designer
| Parser
| Direct
|
| System/Connection built-in Functions / Stored Procedures
|
|
| DATABASE()
|
| YES
| YES
| YES
|
|
| USER()
|
| NO
| NO
| YES
|
|
| CURRENT_USER
|
| YES
| YES
| YES
|
|
| IDENTITY()
|
| YES
| YES
| YES
|
|
|
|
|
|
|
|
|
|
|
| Designer
| Parser
| Direct
|
| System built-in Functions / Stored Procedures
|
|
| IFNULL(exp,value)
|
| YES
| YES
| YES
|
|
| CASEWHEN(exp,v1,v2)
|
| YES
| YES
| YES
|
|
| CONVERT(term,type)
|
| NO
| NO
| YES
|
|
| CAST(term AS type)
|
| YES
| YES
| YES
|
|
| COALESCE(expr1,expr2,expr3,...)
|
| YES
| YES
| YES
|
|
| NULLIF(v1,v2)
|
| YES
| YES
| YES
|
|
| CASE v1 WHEN...
|
| NO
| NO
| YES
|
|
| CASE WHEN...
|
| NO
| NO
| YES
|
|
| EXTRACT
|
| NO
| NO
| YES
|
