DateTime storage and retrival in SQL Azure

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



  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply