SQL Functions
From AgileApps Support Wiki
Revision as of 01:33, 11 November 2011 by imported>Aeric (→Logical Functions)
These functions can be used in your SQL statements.
Logical Functions
IF(expr1,expr2,expr3)' If expr1 is not zero and not null, return expr2. Otherwise, return expr3. IFNULL(expr1,expr2) If expr1 is not NULL, return expr1; Otherwise, return expr2.
String Functions
CONCAT LENGTH
Date Functions
DATE_ADD DATEDIFF CURDATE NOW CURTIME DATE_FORMAT DATE_SUB DATE DAYOFMONTH DAYNAME DAYOFWEEK DAYOFYEAR EXTRACT FROM_UNIXTIME HOUR LAST_DAY MINUTE MONTH MONTHNAME SEC_TO_TIME SECOND STR_TO_DATE SUBTIME TIME_TO_SEC TIME TIMEDIFF TO_DAYS UNIX_TIMESTAMP YEAR
Aggregate Functions
SUM AVG COUNT MAX MIN STD VARIANCE ROUND
Miscellaneous Functions
DISTINCT