SOQL and SOSL Reference
jSOQL SELECT Functions
Use functions in SOQL queries to generate reports for analysis, apply localized
formatting to standard and custom fields, group or filter data by date periods, and
more.
| Functions | Description |
|---|---|
| Aggregate Functions | Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. |
| convertCurrency() | Use convertCurrency() in SOQL queries to convert currency fields to the user’s currency. |
| convertTimezone() | Use convertTimezone() in a date function of SOQL queries to convert dateTime fields to the user’s time zone. |
| Date Functions | Use date functions in SOQL queries to group or filter data by date periods such as day, calendar month, or fiscal year. |
| FORMAT() | Use FORMAT() in SOQL queries to apply localized formatting to standard and custom number, date, time, and currency fields. |
| GROUPING(fieldName) | Use GROUPING(fieldName) in SOQL queries to identify subtotals. |
| toLabel() | Use toLabel() to translate SOQL query results into the language of the user who submits the query. |