Forum OpenACS Q&A: Re: timezone usage
It uses the files in the /usr/share/zoneinfo directory and the zdump command to populate the timezones and timezone_rules OpenACS tables. I'm running Red Hat ES 3, and have not tested it in other Linux flavors.
I think it's a very useful utility and many users will want to use it. So hopefully someone will commit it to the OpenACS CVS tree.
My goal was to get the current *.ctl files in ref-timezones package to be able to load my .dat files but I ran into a problem with generating the timezones-rules.dat file. I was not able to get Tcl's clock procs to format the date to "Mon DD YYYY HH:MI:SS" format. So you have to modify it's .ctl file to load it. The date is in the following format: "Dy Mon DD HH24:MI:SS YYYY".
I'm assuming PostgreSQL can also load such format but I have not tested that.
I uploaded the script to the same location than last time: http://pedroliska.com/files/load-timezones.tcl.txt