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

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Дата
Msg-id 20060302224950.GA19615@winnie.fuhr.org
обсуждение исходный текст
Ответ на Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?  ("Davidson, Robert" <robdavid@amazon.com>)
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Davidson, Robert"
Дата:
Сообщение: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?
Следующее
От: "Simon Kinsella"
Дата:
Сообщение: Re: Help with trigger that updates a row prior to a potentially aborted deletion?