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.
