Difference between revisions of "Список функций, используемых в запросах BASE"
From Apache OpenOffice Wiki
m |
|||
Line 1: | Line 1: | ||
{{RuРазделыFAQ}} | {{RuРазделыFAQ}} | ||
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 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. | ||
+ | |||
+ | Пояснение: | ||
+ | *Значение "YES" в столбце Designer означает, что функцию можно использовать в дизайнере (визуальном конструкторе) запросов. | ||
+ | *В столбце Parser - функция будет работать во время выполнения, даже если дизайнер не понимает функцию. | ||
+ | *Direct означает запрос, в котором включен параметр "SQL Direct" (или параметр EscapeProcessing=False) | ||
{| class="prettytable" | {| class="prettytable" | ||
Line 7: | Line 12: | ||
| | | | ||
| | | | ||
− | | | + | | '''Numerical built-in Functions / Stored Procedures''' |
| '''Designer''' | | '''Designer''' | ||
| '''Parser''' | | '''Parser''' | ||
| '''Direct''' | | '''Direct''' | ||
− | |||
− | |||
|- | |- |
Revision as of 14:40, 22 November 2007
Принять участие в проекте! |
---|
Форматирование ответов |
Вопросы использования |
Популярные разделы: |
Writer: Часто задаваемые вопросы |
Calc: Часто задаваемые вопросы |
Орфография и грамматика |
Полезности и секреты |
Главная страница |
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.
Пояснение:
- Значение "YES" в столбце Designer означает, что функцию можно использовать в дизайнере (визуальном конструкторе) запросов.
- В столбце Parser - функция будет работать во время выполнения, даже если дизайнер не понимает функцию.
- 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 |
Перейти к разделу: Writer | Calc | Общее | UI | Глоссарий | Принятые сокращения | Полезности | Содержание |