DateTime storage and retrival in SQL Azure

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  December 6, 2012 at 2:07 am

  #285906

  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..

  Thanks

  Saravanan.s

• Grant Fritchey

  SSC Guru

  Points: 398679

  More actions

  December 19, 2012 at 12:44 pm

  #1570271

  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

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning