A
ABSOLUTE_VALUE
Return the absolute value of a number.
ARC_COSINE
Returns the arc cosine of a number, in radians.
ARC_SINE
Returns the arc sine of a number, in radians.
ARC_TANGENT
Returns the arc tangent of a number, in radians.
C
CONCAT
Concatenates two strings.
COSINE
Returns the cosine of a number.
CURRENT_DATE
Returns a date based on a reading of the time-of-day clock.
CURRENT_TIME
Returns a time based on a reading of the time-of-day clock.
CURRENT_TMSTP
Returns a timestamp based on a reading of the time-of-day clock.
D
DAY_OF_MONTH
Returns the day part of a value.
DAY_OF_WEEK
Returns an integer between 1 and 7 that represents the day of the week.
DAY_OF_YEAR
Returns an integer between 1 and 366 that represents the day of the year.
E
EXPONENTIAL
Returns a value that is the base of the natural logarithm (e).
F
FLOOR
Returns the largest integer value less than or equal to a numeric argument.
H
HOUR
Returns the hour part of a value.
I
IF_NULL
Returns the first argument that is not null.
IS_NULL_IND
Returns a boolean value that indicates when a column contains the NULL value.
L
LEFT
Returns the leftmost specified number of characters from the string.
LOGARITHM_10
Returns the common logarithm (base 10) of a number.
LOGARITHM_N
Returns the common logarithm (e) of a number.
LOWERCASE
Returns a string in which all the characters are converted to lower case.
LTRIM
Removes blanks or hexadecimal zeros from the beginning of a string expression.
M
MINUTE
Returns the minute part of a value.
MODULO
Divides the first argument by the second argument and returns the remainder.
MONTH
Returns the month part of a value.
P
PI
Returns the value of PI.
POWER_OF
Returns the result of raising the first argument to the power of the second argument.
Q
QUARTER
Returns an integer between 1 and 4 that represents the quarter of the year in which the date resides.
R
RTRIM
Removes blanks or hexadecimal zeroes from the end of a string expression.
S
SECOND
Returns the seconds part of a value.
SINE
Returns the sine of a number.
SQUARE_ROOT
Returns the square root of a number.
STRING_LENGTH
Returns the length of a value.
SUBSTRING
Returns a substring of a string.
T
TANGENT
Returns the tangent of a number.
U
UPPER_CASE
Returns a string in which all the characters have been converted to uppercase characters.
W
WEEK
Returns an integer, between 1 and 53, that represents the week of the year.
Y
YEAR
Returns the year part of a value.