Difference between revisions of "Built-in functions and Stored Procedures"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
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.

Numerical Functions
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


Statistical Functions
Function Desinger Parser Direct
VAR_POP
VAR_SAMP
STDDEV_POP
STDDEV_SAMP


String Fnctions -
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


Date and Time Functions
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


System Functions
Function Desinger Parser Direct
DATABASE() YES YES YES
USER() NO NO YES
CURRENT_USER YES YES YES
IDENTITY() YES YES YES
Personal tools