Dave Witt <[EMAIL PROTECTED]> writes: > 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';
Why are you surprised? Boise would've been on MST not MDT on that date. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers