База Знаний: Base. Список функций, используемых в запросах Base
From Wiki
Jump to navigationJump to search
Пояснение:
- Значение "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 | ||
