>- see footer for list info -< Why not just give them a list of timezones to pick from, store that in the users profile, and then use DateAdd() to alter it accordingly when displaying any date and times to that user.
Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aidan Whitehall Sent: 22 July 2005 16:47 To: [email protected] Subject: [CF-Dev] International datetime Q >- see footer for list info -< We're internationalising / localising a web-app we host for our UK and AUS users. The idea is that we want to accept data from a user and, knowing their locale, store the data along with the UTC time they submitted it. Then, subsequently be able to fish it back out the db and say "you submitted this data at xx:xx" and show them the datetime adjusted back into their timezone. That way, we know all datetimes in the db are UTC. I was making the assumption that we're after something that can return the UTC offset and current DST settings given a particular locale. getTimeZoneInfo() looked like it might do the trick, but it only returns the time zone offset info for the computer on which the function is called (presumably the server). However, I'm now wondering if knowing the locale is actually enough... for the UK, it's straightforward as there's only one timezone, but AUS has multiple timezones, each with their own (weird Johnny-foreigner) TZ offset and DST rules. So, I'm beginning to think we should ask the user for their geographical location instead of just "pick from this list -> English (UK) / English (Australian)". Any pointers on the "correct" way to tackle this would be very much appreciated. Talk about can of worms... -- 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 >-< _______________________________________________ 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 -<
