Difference between revisions of "SQL Functions"

Revision as of 01:18, 11 November 2011

These functions can be used in your SQL statements.

@@ Line 2: / Line 2: @@
 ===LOGICAL FUNCTIONS===
-;IF:
+:;IF:
-;IFNULL:
+:;IFNULL:
 ===String Functions===
-;CONCAT:
+:;CONCAT:
-;LENGTH:
+:;LENGTH:
 ===Miscellaneous===
-;DISTINCT:
+:;DISTINCT:
 ===DATE Functions===
-;DATE_ADD:
+:;DATE_ADD:
-;DATEDIFF:
+:;DATEDIFF:
-;CURDATE:
+:;CURDATE:
-;NOW:
+:;NOW:
-;CURTIME:
+:;CURTIME:
-;DATE_FORMAT:
+:;DATE_FORMAT:
-;DATE_SUB:
+:;DATE_SUB:
-;DATE:
+:;DATE:
-;DAYOFMONTH:
+:;DAYOFMONTH:
-;DAYNAME:
+:;DAYNAME:
-;DAYOFWEEK:
+:;DAYOFWEEK:
-;DAYOFYEAR:
+:;DAYOFYEAR:
-;EXTRACT:
+:;EXTRACT:
-;FROM_UNIXTIME:
+:;FROM_UNIXTIME:
-;HOUR:
+:;HOUR:
-;LAST_DAY:
+:;LAST_DAY:
-;MINUTE:
+:;MINUTE:
-;MONTH:
+:;MONTH:
-;MONTHNAME:
+:;MONTHNAME:
-;SEC_TO_TIME:
+:;SEC_TO_TIME:
-;SECOND:
+:;SECOND:
-;STR_TO_DATE:
+:;STR_TO_DATE:
-;SUBTIME:
+:;SUBTIME:
-;TIME_TO_SEC:
+:;TIME_TO_SEC:
-;TIME:
+:;TIME:
-;TIMEDIFF:
+:;TIMEDIFF:
-;TO_DAYS:
+:;TO_DAYS:
-;UNIX_TIMESTAMP:
+:;UNIX_TIMESTAMP:
-;YEAR:
+:;YEAR:
 ===AGGREGATE Functions===
-;SUM:
+:;SUM:
-;AVG:
+:;AVG:
-;COUNT:
+:;COUNT:
-;MAX:
+:;MAX:
-;MIN:
+:;MIN:
-;STD:
+:;STD:
-;VARIANCE:
+:;VARIANCE:
-;ROUND:
+:;ROUND: