From: Michael Fuhr <mike@fuhr.org>
To: Davidson, Robert <robdavid@amazon.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Date: Thu, 2 Mar 2006 15:49:50 -0700
Message-ID: <20060302224950.GA19615@winnie.fuhr.org> (raw)
In-Reply-To: <D224B13DA625924883A3B024CD6608F001A6B048@exchg-sea5-03.ant.amazon.com>
References: <D224B13DA625924883A3B024CD6608F001A6B048@exchg-sea5-03.ant.amazon.com>
On Thu, Mar 02, 2006 at 02:33:08PM -0800, Davidson, Robert wrote:
> I would like to use daylight savings time aware time zones to
> display dates, but can't seem to get them to work no matter what
> alias I use:
>
> select '2005-02-25 00:00:00 -800' AT TIME ZONE 'CST6CDT' as interval
> ...
> ERROR: time zone "cst6cdt" not recognized
This works only since 8.1. Here's an excerpt from the 8.1 Release
Notes:
* Allow the full use of time zone names in AT TIME ZONE, not just the
short list previously available (Magnus)
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, robdavid@amazon.com
Subject: Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
In-Reply-To: <20060302224950.GA19615@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox