Time Zones

[phaworth]

I need to display times in my app based on the time zone the user is in and the time zone of the time in an entry in my database. I will know which timezone each db entry is in because it also includes full address data. So I have the data I need and could could probably write the code but just wondering if anyone has already done it.
Thanks,
Pete

[bn]

Hi Pete,

look at Sarah's site:
http://www.troz.net/rev/index.irev?category=All#stacks
DateTime and Calendar might give you some ideas.
Sarah is THE expert on time/date in Rev.
regards
Bernd

[Klaus]

...
Sarah is THE expert on time/date in Rev.
...

Yeah, call her CHRONOS!

[bn]

Klaus,

Yeah, call her CHRONOS!

she wouldn't eat her children, would she?

regards
Bernd

[Klaus]

Hmmm, I'm afraid every genius has its dark side(s)...

Sarah, we are just kidding, believe me!

[phaworth]

Thanks everyone. I already use Sarah's date picker stack in my ap, should have thought of that.
Pete

[phaworth]

Just took a quick look at Sarah's date routines and there are a couple in there that will be useful (converting between timestamp and seconds) but nothing specifically to do with time zones and conversion between them.

I think what I need is a function that will take a timestamp, some sort of indication of the geographic location of that timestamp, and another indication of the geographic location I want the timestamp converted to. So something like "If it's 9:30am on June 24th, 2010 in California, what time is it in New Hampshire". I guess I would need a table of states and their respective timezones to do that and I have to deal with Daylight Savings Time issues since some states don't observe it. Plus I really should deal with worldwide locations, not just US states. Gonna be interesting!

Pete

[FourthWorld]

Using "the internet date" produces a format that includes the GMT offset, e.g.:

Thu, 24 Jun 2010 15:51:51 -0700