DataSet / Pacific Timezone Question

From: Amos Soma (amos_j_soma_at_y_a_hoo.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 13:59:09 -0400

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

Relevant Pages

  • Re: Quick Start certificate
    ... I have enabled diagnostics on the client and the web service. ... Did you give your web server identity permission to ... read the certificate on the server? ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Dataset / Pacifice Timezone Question
    ... >>>I have a Web Service on a Web Server on the East Coast ... >>> different time zone, the datetime columns have ... >>> between server and client. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: session object II
    ... web server does not hold a static connection with a client. ... Create a web service on the web server that will accept and return ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Dataset / Pacific Timezone Question
    ... >I have a Web Service on a Web Server on the East Coast ... >been "adjusted" to account for the time zone difference ... >between server and client. ...
    (microsoft.public.dotnet.languages.csharp)
  • Dataset / Pacifice Timezone Question
    ... I have a Web Service on a Web Server on the East Coast ... been "adjusted" to account for the time zone difference ... between server and client. ...
    (microsoft.public.dotnet.framework.adonet)