Re: handling different Timezones

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 10/23/04 

Date: Fri, 22 Oct 2004 20:25:07 -0400

Normally this is done on the application level.

There is no way, other than storing the time as UTC or with time zone
information, that I am aware of doing this.

"William F. Kinsley" <bacardi@online.nospam> wrote in message
news:%23s5YuzHuEHA.1280@TK2MSFTNGP10.phx.gbl...
>I planning on using replication(merge most likely) in an environment where
> the subscribers will be in different timezones. Is there way to convert
> the
> datetime fields from the subscriber's to the local database timezone to
> the
> publishers, and vice versa?
>
> Thanks
>
> --
> +--------------------------------------+
> William F. Kinsley
> Sr. Design Engineer
> NextGen Healthcare Info. Sys. Inc
>
>

Relevant Pages

  • Re: Preparing for daylight saving time changes in 2007
    ... What about any times that you are storing in your ... "TIMESTAMP WITH TIME ZONE is a variant ... and minutes) between local time and UTC ... TIMESTAMPWITH TIME ZONE ...
    (borland.public.delphi.non-technical)
  • Re: Question about ISO8601 vs. strftime()
    ... online references to ISO8601 just get it wrong? ... that link only shows the form with the UTC ... but not the offset as far as I can tell. ... assumed to be in some local time zone. ...
    (comp.programming)
  • Re: Time Zones as politics
    ... be in a different time zone from his arch-rival, ... we are not permitted to criticize him in any way because after ... UTC +5 AKA Eastern Standard Time. ... Soon upon the establishment of the Greenwhich Meridian as the time ...
    (alt.horology)
  • Re: Received mail timestamp is off by 7 hours
    ... It should be one hour ahead of UTC right now. ... Notice that the timestamp on your local e-mail server corresponds to ... the CMOS real-time clock should be set to ... UTC and fix your time zone to match your location. ...
    (freebsd-questions)
  • Re: SWbemDateTime to Win 2k Compatible
    ... UUU is number of minutes to subtract from current time to get UTC. ... The TimeWritten property is not an Integer8 value, ... ' Get current date/time less 2 hours. ... This assumes your time zone bias is -480 minutes. ...
    (microsoft.public.scripting.vbscript)