Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Witt
Subject Difference when using ZIC vs. Timezone Abbr - Bug?
Date
Msg-id 48ADE052.80504@movenetworks.com
Whole thread Raw
Responses Re: Difference when using ZIC vs. Timezone Abbr - Bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [pgsql-www] [FINALLY] the TODO list has migrated to Wiki
Next
From: Albert Cervera i Areny
Date:
Subject: Re: [FINALLY] the TODO list has migrated to Wiki