FogBugz Plugin API > Generic Database Access > Allowed Built-In SQL Functions
The following built-in SQL functions are allowed in CQuery clauses because they are demonstrated to work identically across all supported database platforms:
This list is not necessarily exhaustive.
Aggregators
These functions are aggregator functions, and are valid in SELECT and ORDER BY clauses. They allow a single parameter (e.g. COUNT(ixBug)) , or the special parameter "*" (e.g. COUNT(*)).
- AVG
- COUNT
- MAX
- MIN
- SUM
Single-Parameter Functions
These functions take a single parameter.
- ABS
- COS
- SIN
- TAN
- EXP
- LOG
- LTRIM
- RTRIM
- SPACE
- YEAR
- MONTH
- DAY
Double-Parameter Functions
These functions take two parameters.
- ROUND
- LEFT
- RIGHT
Triple-Parameter Functions
- REPLACE