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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Davidson, Robert" <robdavid(at)amazon(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Date: 2006-03-02 22:49:50
Message-ID: 20060302224950.GA19615@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Simon Kinsella 2006-03-03 00:19:22 Re: Help with trigger that updates a row prior to a potentially aborted deletion?
Previous Message Davidson, Robert 2006-03-02 22:33:08 Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?