Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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