From Apache OpenOffice Wiki
Designer means that the function is allowed in the query designer view.Parser means that the escape processing for replaceable parameters will work with this function, even if the designer view does not recognize it.Direct means a query that has 'SQL Direct' ( or EscapeProcessing = False ) turned on.
|
|
|
|
Designer
|
Parser
|
Direct
|
Numerical built-in Functions / Stored Procedures
|
|
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
|