Sybase Adaptive Server Anywhere - Function Types

Function types
304
Function types
This section groups the available function by type.
Aggregate functions
Aggregate functions summarize data over a group of rows from the database.
The groups are formed using the GROUP BY clause of the SELECT
statement. Aggregate functions are allowed only in the select list and in the
HAVING and ORDER BY clauses of a SELECT statement.
The following aggregate functions are available:
♦ "AVG function " on page 316
♦ "COUNT function " on page 324
♦ "LIST function" on page 344
♦ "MAX function" on page 347
♦ "MIN function" on page 348
♦ "SUM function" on page 370
Data type conversion functions
These functions convert arguments from one data type to another.
♦ The Adaptive Server Anywhere cast function is not currently supported
by Adaptive Server Enterprise.
The following data type conversion functions are available:
♦ "CAST function" on page 318
♦ "CONVERT function" on page 322
♦ "HEXTOINT function" on page 339
♦ "INTTOHEX function" on page 342
Date and time functions
Date and time functions perform operations on date and time data types or
return date or time information.
List of functions
Compatibility
List of functions