7.8 Scalar functions that can be specified in the escape clause
The following table lists the scalar functions that can be specified in the escape clause.
|
Scalar function |
Standard format of scalar function |
|---|---|
|
Mathematical functions |
ABS(number) |
|
ACOS(float) |
|
|
ASIN(float) |
|
|
ATAN(float) |
|
|
ATAN2(float1, float2) |
|
|
CEILING(number) |
|
|
COS(float) |
|
|
DEGREES(number) |
|
|
EXP(float) |
|
|
FLOOR(number) |
|
|
LOG(float) |
|
|
LOG10(float) |
|
|
MOD(integer1, integer2) |
|
|
PI() |
|
|
POWER(number, power) |
|
|
RADIANS(number) |
|
|
RAND([number, number]) |
|
|
ROUND(number, places) |
|
|
SIGN(number) |
|
|
SIN(float) |
|
|
SQRT(float) |
|
|
TAN(float) |
|
|
TRUNCATE(number[, places]) |
|
|
String functions |
ASCII(string) |
|
CHAR(code) |
|
|
CONCAT(string1,string2) |
|
|
LCASE(string) |
|
|
LEFT(string,count) |
|
|
LENGTH(string) |
|
|
LTRIM(string) |
|
|
OCTET_LENGTH(string) |
|
|
REPLACE(string1,string2[,string3]) |
|
|
RIGHT(string,count) |
|
|
RTRIM(string) |
|
|
SUBSTRING(string, start[, length]) |
|
|
UCASE(string) |
|
|
Time and date functions |
CURDATE() |
|
CURRENT_DATE() |
|
|
CURRENT_TIME() |
|
|
CURRENT_TIMESTAMP() |
|
|
CURTIME() |
|
|
DAYOFWEEK(date) |
|
|
DAYOFYEAR(date) |
|
|
EXTRACT(extract-field FROM extract-source) |
|
|
NOW() |
|
|
System function |
USER() |
|
Data type conversion function |
CONVERT(value, SQLtype) |