From Apache OpenOffice Wiki
Пояснение:
- Значение "YES" в столбце Designer означает, что функцию можно использовать в дизайнере (визуальном конструкторе) запросов.
- В столбце Parser - работает во время выполнения запроса с включённым параметром EscapeProcessing, в этом случае будет работать замена именованных параметров (named replaceable parameters), даже если дизайнер не понимает эту функцию.
- Direct означает запрос, в котором включен параметр "SQL Direct" (или параметр EscapeProcessing=False)
|
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
|