Re: Time zone

I would add another thing. Always get, set, calc, and store only UTC
datetimes. That way, you never have any date confusion. Your client side
can easily convert to/from UTC so they can display local times. This also
makes it possible for same client to store a record in home time zone and
change their time zone when they travel and still get and use the datetime
correctly because it converted from UTC and it just works even on their new
timezone.

--
William Stacey [C# MVP]
PCR concurrency library: www.codeplex.com/pcr
PSH Scripts Project www.codeplex.com/psobject


"Arne Vajhøj" <arne@xxxxxxxxxx> wrote in message
news:45f8a2ba$0$90262$14726298@xxxxxxxxxxxxxxxxxx
| Sehboo wrote:
| > Yes, I know exactly what timezone to set for each customer, and since
| > all the customers have their own database, there won't be any
| > confusion, but how/where to set timezone in database?
|
| I think you are taking the wrong approach.
|
| Store all time info in DATETIME columns.
|
| Never let the server set the time - always set the
| time from the client apps.
|
| Always use parameters both to set and get the time.
|
| Then it should always work, because
| the timezone of the server does not matter. You send
| binary time forth and back all the time.
|
| Arne


.

Relevant Pages

  • universal time problem
    ... The client can schedule reminders. ... datetime he wants the reminder sent, ... When my client uses webervice A or B to save the reminder it ends up ... - do every calculation/comparison in UTC. ...
    (microsoft.public.dotnet.framework.webservices)
  • RE: universal time problem
    ... you have set this to UTC, ... So, always serialize DateTime ... > The client can schedule reminders. ... > I have production webservice also, I will call this service B. This ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: universal time problem
    ... Print the UTC when you create it, ... > The client can schedule reminders. ... > datetime he wants the reminder sent, ... > I have production webservice also, I will call this service B. This ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: client to client remote desktop encryption
    ... have the info for client to server and server to client i need info on ... ventilation; avoid extreme temperatures and store in a cool, ... away from open flames, naked flames and old flames; avoid inhaling fumes; ...
    (alt.os.windows-xp)
  • Re: Storing client date and time
    ... > I would like to get the clients date and time and store ... the moment) but without it your "client time" doesn't really mean anything. ... The image tag would point to a server-side script that would evaluate the ...
    (comp.lang.javascript)
Loading