Tom Lane wrote:
> Dave Witt <dwitt(at)movenetworks(dot)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.
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2008-08-22 01:19:58|
|Subject: Re: Proposal: new border setting in psql|
|Previous:||From: Bruce Momjian||Date: 2008-08-22 01:13:10|
|Subject: Re: [HACKERS] [FINALLY] the TODO list has migrated to Wiki|