---
schema_version: "1"
id: 84cbddbb0f366efe785032a90790c588379cedceb551e0ae31c179561dd9e63b
title: SOQL SELECT Functions
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-soql-select-functions.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-functions.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: f8b51ef72afff03ea126f8d785c5ed7a2ea30443e94e519a2a5226e965bc31bd
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# SOQL 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](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-agg-functions.md)     | Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis.                               |
| [`convertCurrency()`](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-sosl-querying-currency-fields.md) | Use `convertCurrency()` in SOQL queries to convert currency fields to the user’s currency.                                   |
| [`convertTimezone()`](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-convert-time-zone.md) | Use `convertTimezone()` in a date function of SOQL queries to convert dateTime fields to the user’s time zone.               |
| [Date Functions](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-date-functions.md)         | Use date functions in SOQL queries to group or filter data by date periods such as day, calendar month, or fiscal year.      |
| [`FORMAT()`](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-format.md)                     | Use `FORMAT()` in SOQL queries to apply localized formatting to standard and custom number, date, time, and currency fields. |
| [`GROUPING(fieldName)`](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-grouping.md)        | Use GROUPING(fieldName) in SOQL queries to identify subtotals.                                                               |
| [`toLabel()`](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-tolabel.md)                   | Use `toLabel()` to translate SOQL query results into the language of the user who submits the query.                         |