How can we improve SQL Managed Instance?

Support regional settings to fix GetDate() function

GetDate still on UTC all the time. For the promised value of MI to be the destination for lift&shift without code changes, this breaks it. Now developers have to review their code and update it for MI and if decided to move the database to their IaaS environment, they have to change it back again.

23 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mohamed Sharaf shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback. We are currently working on supporting non-UTC time zone in Azure SQL Managed Instance.
    We are also interested in your feedback on use cases for changing time zone setting on the existing instances, aside from the trivial case of correcting time zone chosen by mistake.

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Bill Hodder commented  ·   ·  Flag as inappropriate

        Well if you guarantee to add the feature to change the time zone, then we could move to it immediately, as GMT and UTC match for the next few months... so isn’t a problem right now, but will become a major problem for us when DST kicks back in...

      Feedback and Knowledge Base