Difference between revisions of "Список функций, используемых в запросах BASE"
From Apache OpenOffice Wiki
(Initial) |
|||
Line 1: | Line 1: | ||
+ | {{RuРазделыFAQ}} | ||
+ | {| class="prettytable" | ||
+ | | colspan="6" | Dsigner 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''' | ||
+ | |||
+ | |- | ||
+ | | colspan="6" | '''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''' | ||
+ | |||
+ | |- | ||
+ | | colspan="6" | '''Statistical Functions''' | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | VAR_POP | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | VAR_SAMP | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | STDDEV_POP | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | STDDEV_SAMP | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | '''Designer''' | ||
+ | | '''Parser''' | ||
+ | | '''Direct''' | ||
+ | |||
+ | |- | ||
+ | | colspan="6" | '''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 | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | <nowiki>LOCATE(search,s,[start])</nowiki> | ||
+ | | | ||
+ | | 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 | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | <nowiki>SUBSTR(s,start[,len])</nowiki> | ||
+ | | | ||
+ | | YES | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | <nowiki>SUBSTRING(s,start[,len])</nowiki> | ||
+ | | | ||
+ | | YES | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | SUBSTRING(... FROM ... FOR ...) | ||
+ | | | ||
+ | | YES | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | <nowiki>TRIM( [|LEADING| TRAILING| BOTH|] </nowiki>FROM <nowiki><COLUMN> )</nowiki> | ||
+ | | | ||
+ | | '''NO''' | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | UCASE(s) | ||
+ | | | ||
+ | | YES | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | LOWER(s) | ||
+ | | | ||
+ | | YES | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | UPPER(s) | ||
+ | | | ||
+ | | YES | ||
+ | | YES | ||
+ | | YES | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | '''Designer''' | ||
+ | | '''Parser''' | ||
+ | | '''Direct''' | ||
+ | |||
+ | |- | ||
+ | | colspan="6" | '''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 | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | <nowiki>TO_CHAR( <date column>, format String )</nowiki> | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | | | ||
+ | | | ||
+ | | '''Designer''' | ||
+ | | '''Parser''' | ||
+ | | '''Direct''' | ||
+ | |||
+ | |- | ||
+ | | colspan="6" | '''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''' | ||
+ | |||
+ | |- | ||
+ | | colspan="6" | '''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 | ||
+ | |||
+ | |} | ||
[[Category:Полезности]] | [[Category:Полезности]] | ||
− | |||
− | |||
{{Ru СодержаниеFAQ Нижняя часть}} | {{Ru СодержаниеFAQ Нижняя часть}} |
Revision as of 16:45, 21 November 2007
Принять участие в проекте! |
---|
Форматирование ответов |
Вопросы использования |
Популярные разделы: |
Writer: Часто задаваемые вопросы |
Calc: Часто задаваемые вопросы |
Орфография и грамматика |
Полезности и секреты |
Главная страница |
Dsigner 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 |
Перейти к разделу: Writer | Calc | Общее | UI | Глоссарий | Принятые сокращения | Полезности | Содержание |