Re: [HACKERS] Difference when using ZIC vs. Timezone Abbr - Bug? - SOLVED

2008-08-22 Thread Dave Witt 

Ah.. my definition of MDT was flawed; thanks for the help!

Alvaro Herrera wrote:

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 Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

[HACKERS] Difference when using ZIC vs. Timezone Abbr - Bug?

2008-08-21 Thread Dave Witt 

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

Re: [HACKERS] Difference when using ZIC vs. Timezone Abbr - Bug?

2008-08-21 Thread Tom Lane 
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

Re: [HACKERS] Difference when using ZIC vs. Timezone Abbr - Bug?

2008-08-21 Thread Alvaro Herrera 
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 Herrerahttp://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