Forum OpenACS Q&A: Re: timezone usage

Collapse
20: Re: timezone usage (response to 18)
Posted by Don Baccus on 04/19/07 11:41 AM
What would be really helpful would be to modify the script to generate the data in sql/common, which was originally derived from the linux files. In this way fresh installs get the new data, and we can easily write an upgrade script to empty the table and reload it on a version upgrade.
Collapse
21: Re: timezone usage (response to 20)
Posted by Pedro Liska on 04/28/07 01:08 AM
You're right Don. I updated my script to generate such files: timezones.dat and timezones-rules.dat.

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