The fn keyword allows the use of several scalar functions. The function name follows the keyword fn.
where functionCall is one of the following functions:
Character
string formed by appending the second string to the first; if either string
is null, the result is NULL. {fn concat (CharacterExpression, CharacterExpression)
is equivalent to built-in syntax { CharacterExpression || CharacterExpression
}. For more details, see
Square root of floating point number.
{fn sqrt (FloatingPointExpression)}
is equivalent to built-in syntax
Absolute value of number. {fn abs(NumericExpression)} is equivalent
to built-in syntax
Position in the second CharacterExpression of
the first occurrence of the first CharacterExpression, searching from
the beginning of the second character expression, unless startIndex is
specified. {fn locate(CharacterExpression,CharacterExpression [, startIndex]
)} is equivalent to the built-in syntax
A character string formed by extracting length characters from the CharacterExpression beginning at startIndex; the index starts with 1.
MOD
returns the remainder (modulus) of argument 1 divided by argument 2. The result
is negative only if argument 1 is negative. For more details, see
Use the
Note that
To
perform
Note that you should not put a datetime column inside a timestamp arithmetic function in WHERE clauses because the optimizer will not use any index on the column.
Use the
Note
that
To perform
Note that you should not put a datetime column inside a timestamp arithmetic function in WHERE clauses because the optimizer will not use any index on the column.
Returns a timestamp value one month later than the current timestamp.
Returns the number of weeks between now and the specified time on January 1, 2001.