How can we improve Azure SQL Database?

← SQL Database

Need the ability to set a time zone per Azure sql database

We need to be able to set the timezone for an Azure sql or DW database. This should be a database option.

Now we are faced with changing all of our code which references getdate() and similar date functions.

We shouldn't have this extra difficulty in moving to a cloud database.

593 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Mark shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

29 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Adam commented  ·   ·  Flag as inappropriate

    Stop creating infinite loops in flow.

    Sharepoint Designer excludes the triggered workflow when determining whether an item has been updated, ensuring the workflow won't recursively trigger itself in an infinite loop. In Flow there is no such consideration. So when I create a flow to fire every time a list item is changed, and the action is to update something in that list, the action of the flow triggers the flow again. Ergo, infinite loop.

    And stop telling the dev community how to work around it. We know how to work around it and create secondary columns that get flagged. The point is we should not have to come up with a workaround for such a stupid, unnecessary problem.

  • Tanharuki commented  ·   ·  Flag as inappropriate

    Yes,we are waiting for the change that the user can set the time zone of DW and DB..
    Come on,guys!

  • Atsushi Kodama commented  ·   ·  Flag as inappropriate

    I think SQLDB and SQLDW are same, but I'd like to ask that is this also planned for Azure SQL Data Warehouse?

  • Deepesh Gosavi commented  ·   ·  Flag as inappropriate

    Temporary solution was shared by team, need to have permanent solution for SQL database. In such case Financial organisation will take back foot. Microsoft should rectify this issue and enable configuration of Time zone as per Country.

  • Wiwit Khristianto commented  ·   ·  Flag as inappropriate

    Please priority this mods, as it is a fundamental configuration. i can not believe that it was missed in the design stage of azure hyperscale.

  • John commented  ·   ·  Flag as inappropriate

    We absolutely need do be able to use the getdate() function as it was working in an on premise environment... Our sotware has hundreds of modules. It is unthinkable of having to change all getdate() calls for a call to a udf to mimic the old getdate(). Can someone from Microsoft tell us if this will be done in the single database instances same as it has been fixed in the Managed instances?

  • Vandana commented  ·   ·  Flag as inappropriate

    Hi - is this also planned for Azure SQL or just SQL Managed Instance on Azure? thanks.

  • George Camp commented  ·   ·  Flag as inappropriate

    Please provide the ability to configure time at the database level for Platform as a service customers.
    WE have just gone live with our application and this unseen "feature" of ONLY UTC time is killing us!

  • Marc L. Allen commented  ·   ·  Flag as inappropriate

    Any update on this? I've gotten all excited about SQL MI, carefully combed through the limitations (didn't see any timezone issue), sold my company, created a test host, started testing, and BOOM!

    Please, please, don't make me build up a SQL clustered set.

  • Yomi Bazuaye commented  ·   ·  Flag as inappropriate

    Glad to hear that this feature has been added to the backlog. In my opinion this feature should have been available out of the box.

    At this point in time (Late Aug 2018) can anyone from the SQL engineering team give an ETA for the availability of this feature?

  • Danny Lankar commented  ·   ·  Flag as inappropriate

    I have now come across this issue and YES We NEED to be able to set a timezone per azure sql database.

← Previous 1

SQL Database

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice