substring function
Derby Reference Manual
328
The JDBC escape syntax
{fn length(CharacterExpression)}
is equivalent
to the built-in syntax
LENGTH(CharacterExpression)
. For more information, see
locate
Returns the position in the second CharacterExpression of the first occurrence
of the first CharacterExpression. Searches from the beginning of the second
CharacterExpression, unless the startIndex parameter is specified.
locate(CharacterExpression,CharacterExpression [, startIndex] )
The JDBC escape syntax
{fn locate(CharacterExpression,
CharacterExpression [, startIndex] )}
is equivalent to the built-in
syntax
LOCATE(CharacterExpression, CharacterExpression [,
StartPosition] )
. For more information, see
ltrim
Removes blanks from the beginning of a character string expression.
ltrim(CharacterExpression)
The JDBC escape syntax
{fn ltrim(CharacterExpression)}
is equivalent
to the built-in syntax
LTRIM(CharacterExpression)
. For more information, see
rtrim
Removes blanks from the end of a character string expression.
rtrim(CharacterExpression)
The JDBC escape syntax
{fn rtrim(CharacterExpression)}
is equivalent
to the built-in syntax
RTRIM(CharacterExpression)
. For more information, see
.
substring
Forms a character string by extracting length characters from the
CharacterExpression beginning at startIndex. The index of the first character in the
CharacterExpression is 1.
substring(CharacterExpression, startIndex, length)
The JDBC escape syntax
{fn substring(CharacterExpression,
startIndex, length)}
is equivalent to the built-in syntax
SUBSTR(CharacterExpression, startIndex, length)
. For more
information, see
.
ucase
Returns a string in which all alphabetic characters in the argument have been
converted to uppercase.
ucase(CharacterExpression)
The JDBC escape syntax
{fn ucase(CharacterExpression)}
is equivalent
to the built-in syntax
UCASE(CharacterExpression)
. For more information, see
Date and time functions
curdate
Returns the current date.
curdate()
