V9 Update Guide

Additional Scalar Functions Available

FairCom DB SQL now supports additional scalar functions providing your SQL applications greater flexibility.

Function	Description
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 FairCom DB SQL session identifier.
SUBSTRING	Returns the substring of a character string.
TRIM	Removes leading and/or trailing characters from a string.