Tom Lane wrote: > 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.
i.e. try using MST7MDT instead, which behaves more sanely. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
