Re: Dataset / Pacifice Timezone Question

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/18/04 

Date: Sat, 18 Sep 2004 12:31:04 -0700

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.
__________________________________
"Amos Soma" <amos_j_soma@y_a_hoo.com> wrote in message 
news:ebmdnRr5trdu6dHcRVn-hQ@buckeye-express.com...
> How and/or where would I do this?
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:udkJpMSnEHA.3908@TK2MSFTNGP09.phx.gbl...
>> 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.
>> __________________________________
>>
>> "Amos Soma" <amos_j_soma@y_a_hoo.com> wrote in message
>> news:kZWdnd308q5iuNbcRVn-hQ@buckeye-express.com...
>> >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: 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: Performance issues With Impersonation and Delegation
    ... Are you actually seeing any Kerberos traffic with the ... I wrote a command line utility that calls a web service ... By multi-threading the client I ... makes the web server query the DC for every call. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • 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.framework)
  • 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)