SOQL and SOSL Reference

Introduction to SOQL and SOSL
Salesforce Object Query Language (SOQL)
Typographical Conventions in This Document
Quoted String Escape Sequences
Reserved Characters
Alias Notation
SOQL SELECT Syntax
SOQL SELECT Examples
SOQL SELECT Functions
Aggregate Functions
convertCurrency()
convertTimezone()
Date Functions
FORMAT ()
GROUPING( fieldName ) )
toLabel()
Relationship Queries
Change the Batch Size in Queries
SOQL Object Limits and Limitations
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Considerations for Querying Currency Data Using SOQL
Salesforce Object Search Language (SOSL)
PDF

convertTimezone()

SOQL queries in a client application return dateTime field values as Coordinated Universal Time (UTC) values. You can use convertTimezone() in a date function to convert dateTime fields to the user’s time zone.

For example, you could use the convertTimezone(dateTimeField) function to find the sum of the Amount values for all your opportunities for each hour of the day, where the hour is converted to the user's time zone.

1SELECT HOUR_IN_DAY(convertTimezone(CreatedDate)), SUM(Amount)
2FROM Opportunity
3GROUP BY HOUR_IN_DAY(convertTimezone(CreatedDate))

Note that you can only use convertTimezone() in a date function. The following query doesn't work because there is no date function.

1SELECT convertTimezone(CreatedDate)
2FROM Opportunity