These two queries produce different output, using version 8.3.3:
SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'MDT'; SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'America/Boise'; ..is this a bug? Note: "America/Boise"="MDT" (from pg_timezone_names) Best regards, -- Dave Witt -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers