COT

Returns the cotangent of the expression.

CURRENT_DATE

Returns the current date as a DATE value.

CURRENT_TIMESTAMP

A synonymous replacement for SYSTIMESTAMP

CURRENT_USER

Returns the string identifier of the database user.

EXTRACT

Returns a date time field from a date time expression.

LOCALTIME

Returns the current time as a TIME value.

LOCALTIMESTAMP

Returns the current data and time as a TIMESTAMP value.

LOG

Returns the natural log of an expression.

OCTET_LENGTH

Returns the number of bytes in a string.

OVERLAY

Replaces characters in a string.

POSITION

Returns the first occurrence of a character in a string.

SESSION_USER

Returns the value of the c-treeACE SQL session identifier.

SUBSTRING

Returns the substring of a character string.

TRIM

Removes leading and/or trailing characters from a string.