Difference between revisions of "Built-in functions and Stored Procedures"
From Apache OpenOffice Wiki
DrewJensen (talk | contribs) (Base Standard Functions) |
DrewJensen (talk | contribs) m |
||
| Line 287: | Line 287: | ||
|- | |- | ||
|} | |} | ||
| + | |||
| + | |||
| + | [[Category:Database]] | ||
| + | [[Category:Base]] | ||
Revision as of 17:33, 25 August 2007
The HSQLdb database engine included with Base supports the following functions and stored procedures for use within queries.
| Function | Desinger | 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) | YES | YES | 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 |
| Function | Desinger | Parser | Direct |
| VAR_POP | |||
| VAR_SAMP | |||
| STDDEV_POP | |||
| STDDEV_SAMP |
| Function | Desinger | Parser | Direct |
| 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 |
| LEADING| TRAILING| BOTH|] FROM <COLUMN> ) | YES | YES | YES |
| UCASE(s) | YES | YES | YES |
| LOWER(s) | YES | YES | YES |
| UPPER(s) | YES | YES | YES |
| Function | Desinger | Parser | Direct |
| 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 ) | YES | YES | YES |
| Function | Desinger | Parser | Direct |
| DATABASE() | YES | YES | YES |
| USER() | NO | NO | YES |
| CURRENT_USER | YES | YES | YES |
| IDENTITY() | YES | YES | YES |
