SQL Functions
From AgileApps Support Wiki
Revision as of 01:19, 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