FIREBIRD PT

System Functions
==================
DATABASE( )
IFNULL(exp, value)
USER( )
==================
String functions
==================
ASCII(string_exp)
BIT_LENGTH(string_exp)
CHAR(code)
CHAR_LENGTH(string_exp)
CHARACTER_LENGTH(string_exp)
CONCAT(string_exp1, string_exp2)
DIFFERENCE(string_exp1, string_exp2)
INSERT(string_exp1, start, length, string_exp2)
LCASE(string_exp)
LEFT(string_exp, count)
LENGTH(string_exp)
LOCATE(string_exp1, string_exp2[, start])
LTRIM(string_exp)
OCTET_LENGTH(string_exp)
POSITION(character_exp IN character_exp)
REPEAT(string_exp, count)
REPLACE(string_exp1, string_exp2, string_exp3)
RIGHT(string_exp, count)
RTRIM(string_exp)
SOUNDEX(string_exp)
SPACE(count)
SUBSTRING(string_exp, start, length)
UCASE(string_exp)
==================
Numeric functions
==================
ABS(numeric_exp)
ACOS(float_exp)
ASIN(float_exp)
ATAN(float_exp)
ATAN2(float_exp1, float_exp2)
CEILING(numeric_exp)
COS(float_exp)
COT(float_exp)
DEGREES(numeric_exp)
EXP(float_exp)
FLOOR(numeric_exp)
LOG(float_exp)
LOG10(float_exp)
MOD(integer_exp1, integer_exp2)
PI( )
POWER(numeric_exp, integer_exp)
RADIANS(numeric_exp)
RAND([integer_exp])
ROUND(numeric_exp, integer_exp)
SIGN(numeric_exp)
SIN(float_exp)
SQRT(float_exp)
TAN(float_exp)
TRUNCATE(numeric_exp, integer_exp)
==================
Time and date functions
==================
Function Description
CURRENT_DATE( )
CURRENT_TIME[(time-precision)]
CURRENT_TIMESTAMP[(timestamp-precision)]
CURDATE( )
CURTIME( )
DAYNAME(date_exp)
DAYOFMONTH(date_exp)
DAYOFWEEK(date_exp)
DAYOFYEAR(date_exp)
EXTRACT(extract-field FROM extract-source)
HOUR(time_exp)
MINUTE(time_exp)
MONTH(date_exp)
MONTHNAME(date_exp)
NOW( )
QUARTER(date_exp)
SECOND(time_exp)
TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)
WEEK(date_exp)
YEAR(date_exp)
==================