Ross Johnson wrote:
> As PostgreSQL is used all over the Internet, would it be too radical to
> suggest that PostgreSQL drop acronyms in favour of offsets as the default
> when displaying or parsing timezones, and especially when copying in and
> out? Perhaps a modifiable system table could provide correspondence
> between offsets and acronyms for those who want or need to use acronyms.
I agree, but I think there is more to it. In /usr/lib/zoneinfo there
are files describing *** for almost each country *** (and there are many):
leap seconds, transition times and other time related info.
Check out the man-page tzfile(5).
So I guess the time difference between local time and UTC for a specific
country may change many times a year (not only when we switch from/to
Daylight Savings Time). But I'm positive Tom knows a lot more about this.
Cheers,
Ronald
------------------------------
