Difference when using ZIC vs. Timezone Abbr - Bug?
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
Dave Witt <dwitt@movenetworks.com> 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
Tom Lane wrote:
Dave Witt <dwitt@movenetworks.com> 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.
Ah.. my definition of MDT was flawed; thanks for the help!
Alvaro Herrera wrote:
Show quoted text
Tom Lane wrote:
Dave Witt <dwitt@movenetworks.com> 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.