Dataset / Pacifice Timezone Question

  • Thread starter Thread starter Amos Soma
  • Start date Start date
A

Amos Soma

I have a Web Service on a Web Server on the East Coast
which returns a serialized DataSet from my SqlServer at
the same location.

When the DataSet is read by my client in a
different time zone, the datetime columns have
been "adjusted" to account for the time zone difference
between server and client.

For example, if the value in a datetime column on my
database is '1/1/02 12:00 AM', when I retrieve it on a
client machine on Pacific Time, the value is '1/1/02 12:00
AM' in the DataSet on my Web Server, but when the
client "deserializes" the XML back into a DataSet on my
client, the value becomes '12/31/01 9:00 PM'.

Is there a way to disable this behavior so I get the same
dataset at my client that I sent from my Web Service?

Thanks very much
 
Use UTC time.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
How and/or where would I do this?

William (Bill) Vaughn said:
Use UTC time.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Click to expand...
 
Design your system to store universal time instead of local time. When it
comes time to display the value, the application can use locally-configured
timezone settings to adjust the values. SQL Server supports this directly by
use of the GETUTCDATE() function.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top