View source for Список функций, используемых в запросах BASE

From Apache OpenOffice Wiki

← Список функций, используемых в запросах BASE

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

---

You can view and copy the source of this page.

{{RuРазделыFAQ}} Пояснение: *Значение "YES" в столбце '''Designer''' означает, что функцию можно использовать в дизайнере (визуальном конструкторе) запросов. *В столбце '''Parser''' - работает во время выполнения запроса с включённым параметром EscapeProcessing, в этом случае будет работать замена именованных параметров (named replaceable parameters), даже если дизайнер не понимает эту функцию. *'''Direct''' означает запрос, в котором включен параметр "SQL Direct" (или параметр EscapeProcessing=False) {| class="prettytable" | | '''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''' |- | 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:Полезности]] {{Ru СодержаниеFAQ Нижняя часть}}

Return to Список функций, используемых в запросах BASE.