I would like to use daylight savings time aware time zones to display dates, but can't seem to get them to work no matter what alias I use:
select '2005-02-25 00:00:00 -800' AT TIME ZONE 'CST6CDT' as interval
…
ERROR: time zone "cst6cdt" not recognized
select '2005-02-25 00:00:00 -800' AT TIME ZONE 'America/Chicago' as interval
...
ERROR: time zone "america/chicago" not recognized
However non-aware time zones are available:
select '2005-02-25 00:00:00 -800' AT TIME ZONE 'CST' as interval
2005-02-25 02:00:00
select '2005-02-25 00:00:00 -800' AT TIME ZONE 'CDT' as interval
2005-02-25 03:00:00
Setting the time zone works just fine
set time zone 'America/Chicago';
Query returned successfully with no result in 20 ms.
set time zone 'CST6CDT';
Query returned successfully with no result in 20 ms.
There is a file ../pgsql/share/timezone/CST6CDT
And ../pgsql/share/timezone/America/Chicago
select version();
PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3
Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Many thanks,
Robert Davidson
