Getting the name of the timezone, adjusted for daylight saving

Поиск
Список
Период
Сортировка
От Mark Morgan Lloyd
Тема Getting the name of the timezone, adjusted for daylight saving
Дата
Msg-id ihoqsj$vsq$1@pye-srv-01.telemetry.co.uk
обсуждение исходный текст
Ответы Re: Getting the name of the timezone, adjusted for daylight saving
Список pgsql-general
Running 8.4.6 hosted on Linux, if I do this...

SELECT to_char('2011-03-01 12:00' AT TIME ZONE 'GMT0BST', 'HH24:MI TZ');
  to_char
---------
  12:00
(1 row)

..I don't get a timezone- I can live with that.

If I do this...

SELECT to_char(('2011-03-01 12:00' AT TIME ZONE 'GMT0BST')::TIMESTAMP
WITH TIME ZONE, 'HH24:MI TZ');
   to_char
-----------
  12:00 GMT
(1 row)

..then I get the GMT time with a timezone 'GMT'- that's what I want.

But if I do this...

SELECT to_char(('2011-04-01 12:00' AT TIME ZONE 'GMT0BST')::TIMESTAMP
WITH TIME ZONE, 'HH24:MI TZ');
   to_char
-----------
  13:00 GMT
(1 row)

..then I get the time corrected for daylight saving- which is what I
want- but the timezone doesn't indicate that daylight saving has been
applied.

In the general case, how can I get TZ indicating whether daylight saving
is in effect? Alternatively, is there a flag I can retrieve indicating
that a timestamp has been corrected for DST so that I can select an
alternative name for display?

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

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

Предыдущее
От: tuanhoanganh
Дата:
Сообщение: Re: PostgreSQL 9.0 service error : The service did not respond to the start or control request in a timely fashion.
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Store base64 in database. Use bytea or text?