Forum OpenACS Q&A: Re: timezone usage

13: Re: timezone usage (response to 12)
Posted by Jerry Asher on

Can you be more specific as to where the data comes from?  As I mention in, I believe the tables in the OACS have some bad records.  Also, it is important to get new tables every year as timezone rules do change from locale to locale.  I would like to support my clients with the newer data.

14: Re: timezone usage (response to 13)
Posted by Tom Jackson on

Jerry, I believe the data was somehow extracted from the unix timezone files/database. Unfortunately the tool that did the work doesn't seem to be included with the ref-timezone package. If we had the tool, then it might be possible to only populate the database with the required timezones.

After considering the need for repeated events and the use of intervals, timezone data is going to be required.

I'm wondering if in the future we could hack to_char to output a date in the timezone we want, assuming data is in GMT.