Re: handling different Timezones

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Insurgents Intercept Drone Video in King-Size Security Breach (Updated, with Video) [PING BB
    ... opposition to Bear Bottoms's motion to modify THE PRELIMINARY ... So noted by the Federal Court of Usenet Justice proceeding preliminary declaration, ... First the time is set to UTC which is an international time zone based on GMT. ...
    (alt.2600)
  • 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: 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)