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!