| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA Reference Manual |
![[-]](/dwicons/i_colpse.gif)
| Chapter 8: SQL Functions |
Chapter 8
Functions are used to return information from the database. They are allowed anywhere an expression is allowed.
NULL parameters
Unless otherwise stated, any function that receives NULL as a parameter returns NULL.
| Aggregate functions |
| Data type conversion functions |
|
| Date and time functions |
| Date parts |
| Java and SQL user-defined functions |
| Miscellaneous functions |
| Numeric functions |
| String functions |
| System functions |
| Text and image functions |
|
| Alphabetic list of functions |
| ABS function [Numeric] |
| ACOS function [Numeric] |
| ARGN function [Miscellaneous] |
| ASCII function [String] |
| ASIN function [Numeric] |
| ATAN function [Numeric] |
| ATN2 function [Numeric] |
| AVG function [Aggregate] |
| BYTE_LENGTH function [String] |
| BYTE_SUBSTR function [String] |
| CAST function [Data type conversion] |
| CEILING function [Numeric] |
| CHAR function [String] |
| CHARINDEX function [String] |
| CHAR_LENGTH function [String] |
| COALESCE function [Miscellaneous] |
| CONNECTION_PROPERTY function [System] |
| CONVERT function [Data type conversion] |
| COS function [Numeric] |
| COT function [Numeric] |
| COUNT function [Aggregate] |
| DATALENGTH function [System] |
| DATE function [Date and time] |
| DATEADD function [Date and time] |
| DATEDIFF function [Date and time] |
| DATEFORMAT function [Date and time] |
| DATENAME function [Date and time] |
| DATEPART function [Date and time] |
| DATETIME function [Date and time] |
| DAY function [Date and time] |
| DAYNAME function [Date and time] |
| DAYS function [Date and time] |
| DB_ID function [System] |
| DB_NAME function [System] |
| DB_PROPERTY function [System] |
| DEGREES function [Numeric] |
| DIFFERENCE function [String] |
| DOW function [Date and time] |
| ESTIMATE function [Miscellaneous] |
| ESTIMATE_SOURCE function [Miscellaneous] |
| EXP function [Numeric] |
| EXPERIENCE_ESTIMATE function [Miscellaneous] |
| FLOOR function [Numeric] |
| GETDATE function [Date and time] |
| HEXTOINT function [Data type conversion] |
| HOUR function [Date and time] |
| HOURS function [Date and time] |
| IFNULL function [Miscellaneous] |
| INDEX_ESTIMATE function [Miscellaneous] |
| INSERTSTR function [String] |
| INTTOHEX function [Data type conversion] |
| ISNULL function [Miscellaneous] |
| LCASE function [String] |
| LEFT function [String] |
| LENGTH function [String] |
| LIST function [Aggregate] |
| LOCATE function [String] |
| LOG function [Numeric] |
| LOG10 function [Numeric] |
| LOWER function [String] |
| LTRIM function [String] |
| MAX function [Aggregate] |
| MIN function [Aggregate] |
| MINUTE function [Date and time] |
| MINUTES function [Date and time] |
| MOD function [Numeric] |
| MONTH function [Date and time] |
| MONTHNAME function [Date and time] |
| MONTHS function [Date and time] |
| NEXT_CONNECTION function [System] |
| NEXT_DATABASE function [System] |
| NOW function [Date and time] |
| NULLIF function [Miscellaneous] |
| NUMBER function [Miscellaneous] |
| PATINDEX function [String] |
| PI function [Numeric] |
| PLAN function [Miscellaneous] |
| POWER function [Numeric] |
| PROPERTY_DESCRIPTION function [System] |
| PROPERTY function [System] |
| PROPERTY_NAME function [System] |
| PROPERTY_NUMBER function [System] |
| QUARTER function [Date and time] |
| RADIANS function [Numeric] |
| RAND function [Numeric] |
| REMAINDER function [Numeric] |
| REPEAT function [String] |
| REPLICATE function [String] |
| RIGHT function [String] |
| ROUND function [Numeric] |
| RTRIM function [String] |
| SECOND function [Date and time] |
| SECONDS function [Date and time] |
| SIGN function [Numeric] |
| SIMILAR function [String] |
| SIN function [Numeric] |
| SOUNDEX function [String] |
| SPACE function [Miscellaneous] |
| SQRT function [Miscellaneous] |
| STR function [String] |
| STRING function [String] |
| STUFF function [String] |
| SUBSTRING function [String] |
| SUM function [Aggregate] |
| TAN function [Numeric] |
| TEXTPTR function [String] |
| TODAY function [Date and time] |
| TRACEBACK function [Miscellaneous] |
| TRIM function [String] |
| TRUNCATE function [Numeric] |
| TRUNCNUM function [Numeric] |
| UCASE function [String] |
| UPPER function [String] |
| WEEKS function [Date and time] |
| YEARS function [Date and time] |
| YMD function [Date and time] |
|
|