Difference between revisions of "SQL Functions"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 2: | Line 2: | ||
===Logical Functions=== | ===Logical Functions=== | ||
:{| | :{| border="1" cellpadding="5" cellspacing="1" | ||
| '''IF''' || | | '''IF''' || | ||
|- | |- | ||
| Line 9: | Line 9: | ||
===String Functions=== | ===String Functions=== | ||
:{| | :{| border="1" cellpadding="5" cellspacing="1" | ||
| '''CONCAT''' || | | '''CONCAT''' || | ||
|- | |- | ||
| Line 16: | Line 16: | ||
===Date Functions=== | ===Date Functions=== | ||
:{| | :{| border="1" cellpadding="5" cellspacing="1" | ||
| '''DATE_ADD''' || | | '''DATE_ADD''' || | ||
|- | |- | ||
| Line 77: | Line 77: | ||
===Aggregate Functions=== | ===Aggregate Functions=== | ||
:{| | :{| border="1" cellpadding="5" cellspacing="1" | ||
| '''SUM''' || | | '''SUM''' || | ||
|- | |- | ||
| Line 96: | Line 96: | ||
===Miscellaneous Functions=== | ===Miscellaneous Functions=== | ||
:{| | :{| border="1" cellpadding="5" cellspacing="1" | ||
| '''DISTINCT''' || | | '''DISTINCT''' || | ||
|} | |} | ||
Revision as of 01:28, 11 November 2011
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