Spatial date issue in ASP.Net SQL WebService
My server is in the US and I am running a request against it. The data contained in the table on both the remote (US) and Local are the same.
The problem is I am fetching the DataSet using a WebService from a remote server. The Dates column displays Previous Date. For example, the Date column says January 14, 2007, but when you receive it, January 13, 2007.
I cannot determine the cause as all others are working fine.
There are timing issues in datasets, at least in .net 1.1. The dataset automatically adjusts the time to the client's time zone. I am assuming that your client is set to a timezone that is further west than the server. In turn, this pushes time back a few hours, resulting in a transition date from January 14, 2007 to January 13, 2007.
Take a look at this article .
source to share
It is possible that the localization of the database does not match the expected dataset. I'm not sure about the exact specs, but for example it can store the value as EDT, but expecting it to be UTC. So what you can see in the database file, maybe Jan 14, 2007 12:00, but when it is localized in the US, you get Jan 13, 2007 16:00 or something?
Check the time, not just the date, and see if you can identify the pattern. Then you can probably tweak accordingly.
source to share