How do I ignore time zone differences?

[Guest]

I call a web service that returns a dataset with date infomation. I then
store that information in a local database. The web server and the machine I
am calling it from are on different time zones. All of the times that I save
are getting changed. I can see a -7 at the end of the date string in the xml
coming from the web service. I want to get the date as it is stored, I do
not want it converted, which is what .Net seems to be doing. What is the
best way for me to get the datetime from the dataset while ignoring time zone
differences?

 

[bruce barker]

use gmt time.

-- bruce (sqlwork.com)

 

[Cor Ligthert [MVP]]

use gmt time.As they called it in past and now UTC or even ZULU time

http://en.wikipedia.org/wiki/Coordinated_Universal_Time