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.

2 Answers 2


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, 2014 at 6:56
  • See Converting Time Zones in Date Functions for details on how you can query fields into local time.
    – sfdcfox
    Jan 9, 2014 at 12:32
  • Hi, is this applicable to both Date field and Date/Time field?
    – kitokid
    Jan 10, 2014 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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .