>- see footer for list info -<
Then, to cover everything, you would have to give users the choice of (in
their drop-down list of TZs) ...
UTC/GMT +10:00 hours (N.S.W., Vic., A.C.T.)
UTC/GMT +10:00 hours (QLD.)
UTC/GMT +10:00 hours (Tas.)
UTC/GMT +09:30 hours (S.A.)
UTC/GMT +09:30 hours (N.T.)
UTC/GMT +08:00 hours (W.A.)
Store the ID of what TZ they choose against the user, and have another TZ
table, which has the offset in hours, when DST starts, and when DST ends
(easy enough to get off the internet, somewhere like www.timeanddate.com,
for 2005, 2006, etc). Then the calculation should be easy enough to do ...
get UTC time, add number of hours for apt. TZ, then see if current date
falls within DST start and DST end (leave these fields NULL for the States
that don't observe DST), and add 1 more hour if it does. Only thing you will
have to do is update your DST start and end dates once each year.
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 25 July 2005 14:56
To: Coldfusion Development
Subject: RE: [CF-Dev] International datetime Q
>- see footer for list info -<
> OK, as the token Aussie here, your not going to be able to [snip]
>but you still have to know what State the user is in. HTH !
Thanks for all that, Steve.
You've hit the nail on the head... the inability to infer the TZ details
from the user's locale has become apparent.
And knowing the user's TZ doesn't tell you what their local DST rules are.
And then, even if I know the AUS state, there doesn't appear to be an "easy"
way to find out the current UTC offset for that location at the current
point in time (apart from something like the web service you linked to. I'm
not keen on the WS route, however, as it's something we'd need to do
frequently and I don't want our site to break if a call to the WS failed.
> Do you collect address information from your users ?
Nope. But if we could give the user the appropriate options from which to
select, I could store their selection and output compensated times.
Does anyone know of a system whereby you can d/l (say) a text file from an
international time zone authority that contains details of all the worlds
time zones and each location's DST rules that can be parsed and then allow
the user to select from the possible options, store which they pick and
adjust dates & times accordingly?
Having this second just come across it, I'm thinking of something like this:
http://www.worldtimeserver.com/time_zone_guide/ascii.html
At the moment, we're "Melbourne-centric" in our AUS support, so the +10
hours UTC offset is going to work... kinda. However, something more elegant
is definitely required.
--
Aidan Whitehall
Macromedia ColdFusion Developer
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The service is powered
by MessageLabs. For more information on a proactive anti-virus service
working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
>-<
****************************************************************************
Notice: This e-mail and any attachments are confidential and may contain
legally privileged information and/or copyright material of Hansen
Technologies Limited or third parties. Copying, distributing, disclosing,
commercialising or otherwise acting in reliance on this e-mail and any
attachments is strictly prohibited unless you are the addressee of this
e-mail and have written permission to do so. If you have received this
e-mail in error please delete this e-mail (including any copies and
attachments) and contact Hansen Technologies Limited by return e-mail or by
telephone on + 61 39840 3000. Any views expressed in this e-mail are those
of the individual sender and may not necessarily reflect the views of or be
a commitment by the organisation, except where the individual sender has the
authority and expressly states them to be so.
****************************************************************************
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
