ESL Documentation

Navigation: » No topics above this level «

Built-in Functions (Computed Column)

The following built-in functions are available in the Function list box of the Computed Column dialog box.

AVG	Returns the average of a set of numbers
CHAR	Returns a string representation of a datetime value.
COUNT	Returns the number of rows or values in a set of rows or values.
DATE	Returns a date from a value.
DAY	Returns the day part of a value.
DAYS	Returns an integer representation of a date.
HOUR	Returns the hour part of a value.
LENGTH	Returns the length of a value.
MAX	Returns the maximum value in a set of values.
MICROSECOND	Returns the microsecond part of a value.
MIN	Returns the minimum value in a set of values.
MINUTE	Returns the minute part of a value.
MONTH	Returns the month part of a value.
SECOND	Returns the seconds part of a value.
SUBSTR	Returns a substring of a string.
SUM	Returns the sum of a set of numbers.
TIME	Returns a time from a value.
TIMESTAMP	Returns a timestamp from a value or a pair of values.
TRANSLATE	Returns a translated string.
YEAR	Returns the year part of a value.