You can specify functions in JDBC escape syntax, by using the
where functionCall is the name of one of the following scalar functions:
The
JDBC escape syntax {fn abs(NumericExpression)} is equivalent to the
built-in syntax
The
JDBC escape syntax {fn acos(number)} is equivalent to the built-in
syntax ACOS(number). For more information, see
The
JDBC escape syntax {fn asin(number)} is equivalent to the built-in
syntax ASIN(number). For more information, see
The
JDBC escape syntax {fn atan(number)} is equivalent to the built-in
syntax ATAN(number). For more information, see
The
JDBC escape syntax {fn ceiling(number)} is equivalent to the built-in
syntax CEILING(number). For more information, see
Character string formed by appending the second string to the first string.
If either string is null, the result is NULL. The JDBC escape syntax {fn concat
(CharacterExpression, CharacterExpression) is equivalent to
the built-in syntax { CharacterExpression || CharacterExpression }. For more
information, see
The
JDBC escape syntax {fn cos(number)} is equivalent to the built-in syntax
COS(number). For more information, see
The
JDBC escape syntax {fn degrees(number)} is equivalent to the built-in
syntax DEGREES(number). For more information, see
The
JDBC escape syntax {fn exp(number)} is equivalent to the built-in syntax
EXP(number). For more information, see
The
JDBC escape syntax {fn floor(number)} is equivalent to the built-in
syntax FLOOR(number). For more information, see
The
JDBC escape syntax {fn locate(CharacterExpression,CharacterExpression [, startIndex]
)} is equivalent to the built-in syntax
The
JDBC escape syntax {fn log(number)} is equivalent to the built-in syntax
LOG(number). For more information, see
The
JDBC escape syntax {fn log10(number)} is equivalent to the built-in
syntax LOG10(number). For more information, see
For
more information, see
The
JDBC escape syntax {fn pi()} is equivalent to the built-in syntax PI(). For
more information, see
The
JDBC escape syntax {fn radians(number)} is equivalent to the built-in
syntax RADIANS(number). For more information, see
The
JDBC escape syntax {fn sin(number)} is equivalent to the built-in syntax
SIN(number). For more information, see
The
JDBC escape syntax {fn sqrt (FloatingPointExpression)} is equivalent
to the built-in syntax
The
JDBC escape syntax {fn tan(number)} is equivalent to the built-in syntax
TAN(number). For more information, see
The
To
perform
You should not put a datetime column inside of a timestamp arithmetic function in WHERE clauses because the optimizer will not use any index on the column.
The
To
perform
You should not put a datetime column inside of a timestamp arithmetic function in WHERE clauses because the optimizer will not use any index on the column.
To return a timestamp value one month later than the current timestamp, use the following syntax:
To return the number of weeks between now and the specified time on January 1, 2008, use the following syntax: