The optional precision defaults and

REMAINDER(n, m) Returns the remainder of n divided by m. The remainder is defined as follows: n−(m*ROUND(n/m)).

ROUND(n) Returns n rounded to the nearest integer.

SQRT(n) Returns the square root n, which must be greater than or equal to 0.

TAN(n) Returns the tangent of the angle n, which must be expressed in radians.

TRUNC(n [, p]) Truncates n to m decimal places. The optional precision p defaults to 0 and, if negative, truncates (zeros out) p places to left of the decimal.

Date and time functions

MULTISET(subquery) } AS type)

collection type to another. Use the MULTISET keyword when casting to a collection type.

DBTIMEZONE Returns the time zone offset (from UTC) of the database time zone in the form of a character string in format [+|-]HH24:MI; for example, -05:00.

EXTRACT(element FROM Returns the value of a specific datetime expression) element from the datetime expression. The element can be one of YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, or TIMEZONE_ABBR.