locked
Why my typed time is always 1 hour later? RRS feed

  • 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

  • Hello,

    There is no bug. Time in SQL Server is stored in UTC format.


    Dynamics CRM MVP
    My blog

    • 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 AM
    Moderator
  • 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

  • Hello,

    There is no bug. Time in SQL Server is stored in UTC format.


    Dynamics CRM MVP
    My blog

    • 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 AM
    Moderator
  • 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