Difference when using ZIC vs. Timezone Abbr - Bug?

From: Dave Witt <dwitt(at)movenetworks(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Difference when using ZIC vs. Timezone Abbr - Bug?
Date: 2008-08-21 21:38:26
Message-ID: 48ADE052.80504@movenetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Albert Cervera i Areny 2008-08-21 22:18:51 Re: [FINALLY] the TODO list has migrated to Wiki
Previous Message Alvaro Herrera 2008-08-21 21:19:17 Re: [HACKERS] [FINALLY] the TODO list has migrated to Wiki