Administration Guide › Accessing Collected Events with ODBC and JDBC › Creating ODBC and JDBC Queries for Use with CA User Activity Reporting Module › Supported SQL Functions

Supported SQL Functions

The following are the supported SQL functions for use in building SELECT statements:

• ABS(numeric_exp)
• ROUND(numeric_exp, integer_exp)
• LCASE(string_exp)
• LOWER(string_exp)
• LENGTH(string_exp)
• LTRIM(string_exp)
• RTRIM(string_exp)
• SUBSTRING(string_exp, start,length)
• UCASE(string_exp)
• UPPER(string_exp)
• IFNULL (expr, default_val)
• ISNULL (expr, default_val)
• NVL (expr, default_val)
• CONVERT (value_exp, data_type)
• CURDATE()
• CURTIME()
• CURTIMESTAMP()
• DATEADD(datepart, number, date)
• TIMESTAMPADD(datepart, number, date)
• DATEDIFF(datepart, startdate, enddate) For datepart, the values Year, Day, and second are allowed.
• TIMESTAMPDIFF(datepart, startdate, enddate) For datepart, the values Year, Day, and second are allowed.
• DAYOFMONTH(date_exp)
• DAYOFWEEK(date_exp)
• DAYOFYEAR(date_exp)
• HOUR(time_exp)
• MINUTE(time_exp)
• MONTH(date_exp)
• NOW( )
• SECOND(time_exp)
• WEEK(date_exp)
• YEAR(date_exp)
• AVG([ALL | DISTINCT]expression)
• SUM([ALL | DISTINCT]expression)
• COUNT({[ALL | DISTINCT]expression] | *})
• MAX([ALL | DISTINCT]expression)
• MIN([ALL | DISTINCT]expression)