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.

426 votes

Vote

(thinking…)

oidc

Forgot password?

Create a password

Signed in as (Sign out)

You have left! (?) (thinking…)

Mark shared this idea · March 27, 2017 · Flag idea as inappropriate… · Admin →

planned ·

AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded · May 24, 2019

Planned for SQL DB- no time frame to share yet. Available in SQL Managed Instance

Show previous admin responses (1)

26 comments

Add a comment…

Attach a File

(thinking…)

oidc

Forgot password?

Create a password

Signed in as (Sign out)

Submitting...

Deepesh Gosavi commented · June 04, 2019 03:42 · 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 · May 29, 2019 19:30 · 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 · May 24, 2019 15:20 · Flag as inappropriate

Thank you much appreciated.
John commented · May 22, 2019 14:12 · 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 · April 10, 2019 14:29 · Flag as inappropriate

Hi - is this also planned for Azure SQL or just SQL Managed Instance on Azure? thanks.
Mariana commented · April 05, 2019 07:41 · Flag as inappropriate

Do we have any update on Time Zone setting for MI?
George Camp commented · December 13, 2018 10:24 · 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!
Justin commented · November 29, 2018 07:26 · Flag as inappropriate

This is marked as started in Managed Instance Feedback

https://feedback.azure.com/forums/915676-sql-managed-instance/suggestions/35658055-support-regional-settings-to-fix-getdate-functio
Hitesh Patel commented · October 24, 2018 10:17 · Flag as inappropriate

Do we have any update on Time Zone setting for Managed Instance?
Marc L. Allen commented · October 17, 2018 10:49 · 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.
Anonymous commented · September 24, 2018 08:51 · Flag as inappropriate

Any plans to include this function for SQL Logical Server and Pools?
Anonymous commented · September 24, 2018 08:44 · Flag as inappropriate

Hi, I won't be original, but... Any updates on ETA yet?
Bill Hodder commented · September 13, 2018 08:56 · Flag as inappropriate

Any update on this? GA for SQL MI is only a few weeks away....
Tomasz K commented · August 22, 2018 02:56 · Flag as inappropriate

Managed instances in preview (as per https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-transact-sql-information ) " GETDATE() and other built-in date/time functions always returns time in UTC time zone. See GETDATE". This will be available in GA?
Yomi Bazuaye commented · August 21, 2018 01:52 · 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 · August 09, 2018 14:12 · 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.
Joe Rather commented · August 07, 2018 08:25 · Flag as inappropriate

I agree with Mark. We need this in PaaS as well as IaaS.
Mark Freeman commented · August 06, 2018 07:55 · Flag as inappropriate

Implementing this in SQL MI would be helpful. However, we need it in Azure SQL Database as well.
Sajith commented · July 30, 2018 19:22 · Flag as inappropriate

We moved our db to paas with lot of expectation , and we moved back all our instances to iaas because of the timezone issue. And, this is not mentioned in Limitation documentation https://docs.microsoft.com/en-us/azure/postgresql/concepts-limits .Though application layer maintain the required timezone for those queries pass through , big application like ours uses many reports which fire direct db queries, sometime we import data directly to staging tables , support team executes all basic queries against time.
Drazen Sumic commented · July 11, 2018 06:56 · Flag as inappropriate

We understand the functional ask and that is a significant pain point when migrating the app to the cloud. We have added this feature to the plan for the SQL Database Managed Instance, and funded the engineering work on it. The setting planned is at the instance level (set at the instance creation time), which means it would be applied to all time-zone sensitive functionality on the Managed Instance, so getdate() but also other appropriate functions, system views, etc. I can't share a timeline publicly yet.

SQL engineering team.