locked
Azure Database Server Time Wrong RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Noticed that the server time stamp on my SQL AZure instance is an hour behind UK time, can I specify server time?
    Wednesday, July 20, 2011 4:00 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You cannot change the server time.  I believe all SQL Azure servers are set to UTC time.

    Wednesday, July 20, 2011 4:17 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    You cannot change the server time.  I believe all SQL Azure servers are set to UTC time.

    Wednesday, July 20, 2011 4:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Marc,

    As Michael wrote, SQL Azure provides always the UTC time and UK standard time is UTC+1.

    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing
    Wednesday, July 20, 2011 4:46 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    SQL Azure does not allow setting TimeZone out of the box, but yes there is a workaround:

    http://netindonesia.net/blogs/wely/archive/2011/07/10/managing-timezone-in-sql-azure.aspx

    see, if it could help you. And an honest disclaimer from the author: "it's a trick/workaround, and not a solution"

     

    Paras Doshi ( Blog | Twitter ) 
    • Proposed as answer by wely_live Thursday, July 21, 2011 3:34 AM
    Wednesday, July 20, 2011 5:30 PM