I have one object which has one date/time field.

When I query that field value using workbench,it display as [2014-01-07T19:04:00.000Z ].

But when I go and check from force.com UI, it display as [08/01/2014 03:04].

What is happening? My timezone is Singapore.

How can I solve this issue?

As it makes us problem in querying the data from the db, leads us to get incorrect values.


Date values are always stored in UTC-00:00, while the UI will show times adjusted for your time zone. The "Z" indicates that the time is in UTC-00:00 time zone, and that you will have to adjust to find the time as it relates to you.

  • hi how can i convert to the singapore time zone before making the query? could you able to provide some code sample? – kitokid Jan 9 '14 at 6:56
  • See Converting Time Zones in Date Functions for details on how you can query fields into local time. – sfdcfox Jan 9 '14 at 12:32
  • Hi, is this applicable to both Date field and Date/Time field? – kitokid Jan 10 '14 at 1:26

Using with convertTimezone couldn't fulfill my requirement, I just use

format('dd/MM/yyyy HH:mm') 

to convert into local timezone.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.