SQL Functions
From AgileApps Support Wiki
Revision as of 01:24, 11 November 2011 by imported>Aeric
These functions can be used in your SQL statements.
Logical Functions
IF IFNULL
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