Difference between revisions of "Built-in functions and Stored Procedures"
From Apache OpenOffice Wiki
DrewJensen (Talk | contribs) m |
DrewJensen (Talk | contribs) m |
||
Line 290: | Line 290: | ||
[[Category:Database]] | [[Category:Database]] | ||
− | [[Category:Base]] | + | [[Category:Base Documentation]] |
Revision as of 17:34, 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 |