Список функций, используемых в запросах BASE
From Apache OpenOffice Wiki
Revision as of 14:33, 22 November 2007 by Helen russian (talk | contribs)
Принять участие в проекте! |
---|
Форматирование ответов |
Вопросы использования |
Популярные разделы: |
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.
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 | Глоссарий | Принятые сокращения | Полезности | Содержание |