DateTime Discrepancy

Question

Hey All

Just noticed an issue when inserting an object into my database with a DATE Column.
I have an object called a SalesOrder. In my app a sales order has an OrderDate Field which gets filled out automatically via DateTime.Today.

The issue is, when I run a breakpoint at the time of the object being inserted, the DateTime values are correct.

But when I view the database, the field for order date is incorrect. It makes it the day before.

Just wondering if this is caused by my SQL Server being located in US, and it does some sort of time conversion, and would this be fixed if I created my SQL Server and Database to somewhere closer.

Thanks in advanced!

Answer 1

@Adrian N Thank you for reaching out.

It seems like the machine where the code is being debugged and the server where the database is hosted are in different time zones/locales.
This should get corrected if you match the time zone settings on both machines.

However, the recommended way of storing time stamps is to convert them to UTC first and then store in the database.
When you retrieve the value, you convert them from UTC into the time zone of the client application.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.