Postgres Pro
Downloads
Home   >   mailing lists

Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause? - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Date
Msg-id 20060302224950.GA19615@winnie.fuhr.org
Whole thread Raw
In response to Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?  ("Davidson, Robert" <robdavid@amazon.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Davidson, Robert"
Date:
Subject: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Next
From: "Simon Kinsella"
Date:
Subject: Re: Help with trigger that updates a row prior to a potentially aborted deletion?