Difference between revisions of "SQL Functions"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 1: | Line 1: | ||
These functions can be used in your [[SQL Syntax|SQL]] statements. | These functions can be used in your [[SQL Syntax|SQL]] statements. | ||
=== | ===Logical Functions=== | ||
:;IF: | :;IF: | ||
:;IFNULL: | :;IFNULL: | ||
| Line 9: | Line 9: | ||
:;LENGTH: | :;LENGTH: | ||
=== | ===Date Functions=== | ||
:;DATE_ADD: | :;DATE_ADD: | ||
:;DATEDIFF: | :;DATEDIFF: | ||
| Line 43: | Line 40: | ||
:;YEAR: | :;YEAR: | ||
=== | ===Aggregate Functions=== | ||
:;SUM: | :;SUM: | ||
:;AVG: | :;AVG: | ||
| Line 52: | Line 49: | ||
:;VARIANCE: | :;VARIANCE: | ||
:;ROUND: | :;ROUND: | ||
===Miscellaneous Functions=== | |||
:;DISTINCT: | |||
Revision as of 01:19, 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