Answered by:
Why my typed time is always 1 hour later?

Question
-
Hi everyone,
I typed time for an appointment as below:
But when I check data in SQL Server, I saw the data:
Why the stored time is 1 hour earlier than what I typed?
How to resolve this issue?
Is that a CRM bug?
Additional information, the time zones of local and server are same.
Regards.
- Edited by George Hua Wednesday, April 15, 2015 7:21 AM
Wednesday, April 15, 2015 7:20 AM
Answers
-
- Proposed as answer by Minal Dahiya Wednesday, April 15, 2015 8:38 AM
- Marked as answer by George Hua Wednesday, April 15, 2015 10:04 AM
Wednesday, April 15, 2015 7:22 AMModerator -
Hi
Andrii is correct. CRM always stores time in the database in UTC. Always use the filtered views to read any data from the database.
Hope this helps.
-----------------------------------------------------------------------
Minal Dahiya
blog : http://minaldahiya.blogspot.com.au/If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
- Marked as answer by George Hua Friday, April 17, 2015 2:23 AM
Wednesday, April 15, 2015 8:39 AM
All replies
-
- Proposed as answer by Minal Dahiya Wednesday, April 15, 2015 8:38 AM
- Marked as answer by George Hua Wednesday, April 15, 2015 10:04 AM
Wednesday, April 15, 2015 7:22 AMModerator -
Hi
Andrii is correct. CRM always stores time in the database in UTC. Always use the filtered views to read any data from the database.
Hope this helps.
-----------------------------------------------------------------------
Minal Dahiya
blog : http://minaldahiya.blogspot.com.au/If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
- Marked as answer by George Hua Friday, April 17, 2015 2:23 AM
Wednesday, April 15, 2015 8:39 AM