Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference when using ZIC vs. Timezone Abbr - Bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Difference when using ZIC vs. Timezone Abbr - Bug?
Date
Msg-id 27247.1219365970@sss.pgh.pa.us
Whole thread Raw
In response to Difference when using ZIC vs. Timezone Abbr - Bug?  (Dave Witt <dwitt@movenetworks.com>)
Responses Re: Difference when using ZIC vs. Timezone Abbr - Bug?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP patch: reducing overhead for repeat de-TOASTing
Next
From: Tom Lane
Date:
Subject: Re: [pgsql-www] [FINALLY] the TODO list has migrated to Wiki