Difference between revisions of "SQL Functions"

Revision as of 01:17, 11 November 2011

These functions can be used in your SQL statements.

@@ Line 1: / Line 1: @@
 These functions can be used in your [[SQL Syntax|SQL]] statements.
+===LOGICAL FUNCTIONS===
+;IF:
+;IFNULL:
+===String Functions===
+;CONCAT:
+;LENGTH:
+===Miscellaneous===
+;DISTINCT:
+===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: