Search code examples
sqlazure-sql-databasegetdate

SQL GetDate() returns wrong time

I am having an issue while using GetDate(), for some reason is not returning the right time (it is 7 hours ahead from the actual time) I am using AZURE and the Database is configured with the right location (West US). I will appreciate any help!

I tried to run this script:

SELECT id,
       status,
       AcceptedDate,
       Getdate(),
       Datediff(hour, AcceptedDate, Getdate())
FROM   orderoffers
WHERE  status = 'Accepted'
Solution

  • Azure SQL Databases are always UTC, regardless of the data center. You'll want to handle time zone conversion at your application.

    In this scenario, since you want to compare "now" to a data column, make sure AcceptedDate is also stored in UTC.

    Reference