> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--MS_Mac_OE_3055854202_486236_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Yep, totally agree with Jeff. Store in one timezone only (GMT). Ask/confirm
with the user their local date and time (could pre-populate such fields
using JavaScript) and store the difference +/- as a user preference.
I have two tables, tdCounrties (49 rows) and their regions, tdRegions (1545
rows). Unfortunately doesn't have the daylight savings time/date range
against the countries or regions though. Can e-mail if you like.
This would at least give you something to manage the exceptions by. For
example, because of the Olympics held in Sydney this year, they went to
daylight savings almost something like 6 weeks earlier than normal, that
would really mess your doctors up :) Maybe someone out their has some tables
that have the daylight saving schedule for a table of countries?
m
--
Malcolm Barclay
Rocket Company Pty Ltd
From: "Jeff Peters" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 30 Oct 2000 22:26:27 -0500
To: Fusebox <[EMAIL PROTECTED]>
Subject: RE: multiple timezones
Store user's time zone as +/- Zulu (GMT) in their profile; store appointment
times in the database as Zulu; display times to user as [database time] -
[user's time zone]; store appointment times from entry form as
[entered value] + [user's time zone]
Example: EST (-5 Zulu)
I enter appointment time of 05:00. Time is stored in database as 00:00
(appointment + timezone). When I look at my appointments, time is displayed
as
05:00 (Zulu - timezone).
- Jeff
On 30 Oct 00, at 19:13, wish wish wrote:
> the problem is that depending on the timezone that the user is located
> i have to show the appointment time(server time) in user's local time.
> with all different time zones in the world, daylight savings time as well as
> some of the exceptions like Arizona...
> this is not an easy task.
> any inputs?
>
>
> >From: Jeffrey Marsh <[EMAIL PROTECTED]>
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--MS_Mac_OE_3055854202_486236_MIME_Part
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: multiple timezones</TITLE>
</HEAD>
<BODY>
Yep, totally agree with Jeff. Store in one timezone only (GMT). Ask/confirm=
with the user their local date and time (could pre-populate such fields usi=
ng JavaScript) and store the difference +/- as a user preference.<BR>
<BR>
I have two tables, tdCounrties (49 rows) and their regions, tdRegions (1545=
rows). Unfortunately doesn't have the daylight savings time/date range agai=
nst the countries or regions though. Can e-mail if you like.<BR>
<BR>
This would at least give you something to manage the exceptions by. For exa=
mple, because of the Olympics held in Sydney this year, they went to dayligh=
t savings almost something like 6 weeks earlier than normal, that would real=
ly mess your doctors up :) Maybe someone out their has some tables that have=
the daylight saving schedule for a table of countries?<BR>
<BR>
m<BR>
<BR>
-- <BR>
Malcolm Barclay<BR>
Rocket Company Pty Ltd<BR>
<BR>
<BLOCKQUOTE><BR>
<B>From: </B>"Jeff Peters" <[EMAIL PROTECTED]><BR>
<B>Reply-To: </B>[EMAIL PROTECTED]<BR>
<B>Date: </B>Mon, 30 Oct 2000 22:26:27 -0500<BR>
<B>To: </B>Fusebox <[EMAIL PROTECTED]><BR>
<B>Subject: </B>RE: multiple timezones<BR>
<BR>
</BLOCKQUOTE><BR>
<BLOCKQUOTE><TT>Store user's time zone as +/- Zulu (GMT) in their profile; =
store appointment <BR>
times in the database as Zulu; display times to user as [database time] - <=
BR>
[user's time zone]; store appointment times from entry form as <BR>
[entered value] + [user's time zone]<BR>
<BR>
Example: EST (-5 Zulu)<BR>
I enter appointment time of 05:00. Time is stored in database as 00:0=
0 <BR>
(appointment + timezone). When I look at my appointments, time is displayed=
as <BR>
05:00 (Zulu - timezone).<BR>
<BR>
- Jeff<BR>
<BR>
On 30 Oct 00, at 19:13, wish wish wrote:<BR>
<BR>
> the problem is that depending on the timezone that the user is located=
<BR>
> i have to show the appointment time(server time) in user's local time.=
<BR>
> with all different time zones in the world, daylight savings time as w=
ell as <BR>
> some of the exceptions like Arizona...<BR>
> this is not an easy task.<BR>
> any inputs?<BR>
> <BR>
> <BR>
> >From: Jeffrey Marsh <[EMAIL PROTECTED]><BR>
<BR>
---------------------------------------------------------------------------=
---<BR>
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&a=
mp;body=3Dlists/fusebox or send a message to [EMAIL PROTECTED]=
with 'unsubscribe' in the body.<BR>
</TT></BLOCKQUOTE><TT><BR>
</TT>
</BODY>
</HTML>
--MS_Mac_OE_3055854202_486236_MIME_Part--
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
