OpenACS / openacs-4 / packages / ref-timezones

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 21 Jul
Commits this week: 0
Total Lines of Code (LoC): 185,160
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 08 Feb 2024
7:40 pm

gustafn

Updates timezone data once again, bump version to 5.10.1b3

The timezone data from IANA has changed (probably several years ago),

and the min/max years have to be changed to -2147481748/2147485547,

which are no acceptable years for timestamps in PostgreSQL and

Oracle. The new timezone data maps now these boundary values 1/9999.

This commit fixes as well a bug introduced by the last version of the

timezone data in cases, where Tcl versions with older timezone data

were used, and the fallback operations based on Tcl failed. Tcl

versions 8.6.14* and Tcl 9.0* have up-to-date time zones, e.g. Tcl

8.6.13 still requires in some rare cases the fallback to the database,

where the error might show up.

Options
    • -80739
    • +81885
    ./common/timezone-rules.dat
    • -162
    • +210
    ./common/timezones.dat
    • -4
    • +5
    ./postgresql/upgrade/upgrade-timezones.ctl
  4. … 2 more files in changeset.
Sunday 04 Feb 2024
6:46 pm

gustafn

Upgrade timezone data to tzdb-2024a (Released 2024-02-01) from IANA

The last update of the timezone data of OpenACS happened on Sep 29,

2015 in the release process of OpenACS 5.9.0. The new timezone data is

based on the newest released data from IANA reflecting the changes

made by political bodies to time zone boundaries, UTC offsets, and

daylight-saving rules. The procedures to update the database are

described in RFC 6557 (https://www.rfc-editor.org/rfc/rfc6557.html)

and contains data for e.g. Europe up to the year 2499.

Options
    • -36419
    • +220430
    ./common/timezone-rules.dat
    • -505
    • +459
    ./common/timezones.dat
  3. … 2 more files in changeset.