Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DateTime storage and retrival in SQL Azure Expand / Collapse
Posted Thursday, December 6, 2012 2:07 AM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 22, 2015 10:34 PM
Points: 286, Visits: 1,286
Hello All,

I have deployed the SQL Database in to SQL Azure database :

But I don't know, What will be the server-date and time:

how do we know the date offset / DateZone of SQL Azure server ? I created the SQL server with southeast region:

Is there any way to configure the Customized data zone..


Many Thanks!
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”
Post #1393377
Posted Wednesday, December 19, 2012 12:44 PM



Group: General Forum Members
Last Login: Today @ 10:02 AM
Points: 15,976, Visits: 30,340
Your safest bet there is to use the UTC dates. If you do anything else, you're likely to run into a problem. While they will have a bias towards keeping your data in the southeast, there's no guarantee. So you can cover it by always setting your dates to a specific value, UTC is best.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1398627
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse