I have the following date in my DB: 2014-07-31 00:00:00.000
I use ASP to format it when displayed: <%= ((ContactDetails.Fields.Item("ExpiresOn").Value)) %>
On my live server its all good. It shows: 07/31/2014
But the exact same DB (restored from server) in my local environment when I open the page it shows: 31/07/2014
What configuration on my SQL Server could be different to cause this issue ?
It is the exact same ASP code, the exact same DB. The only difference its where the DB is. Both are MS SQL 2008 servers.