Difference between revisions of "RU/kb/00000358"

From Wiki
Jump to navigationJump to search
(RUsignyear)
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{DISPLAYTITLE:База Знаний: {{OOoB|1}}. Список функций, используемых в запросах Base}}
+
<section begin=title /><noinclude>{{DISPLAYTITLE:База Знаний: {{OOoB|1}}. </noinclude>Список функций, используемых в запросах {{OOoB|1}}<noinclude>}}</noinclude><section end=title />
[[RU/kb/base_query|База Знаний: {{OOoB|1}}. Запросы]]
+
{{BreadCrumbL10n|RU/kb/module/base/query}}
 
__NOTOC__
 
__NOTOC__
  
Line 861: Line 861:
  
  
{{RUsignyear|Helen_russian|Е. Ушакова|2007}}
+
{{SignYear|Sancho|А. Е. Харламенков|2011}}
{{KbBaseBottom}}
+
{{RUkbBaseBottom}}

Latest revision as of 17:23, 17 September 2011


Пояснение:

  • Значение "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












К началу страницы