Re: BUG #1232: Singapore Timezone missing

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #1232: Singapore Timezone missing
Дата
Msg-id 0ede01c48b18$a808c700$0200a8c0@hogranch.com
обсуждение исходный текст
Ответ на BUG #1232: Singapore Timezone missing  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Список pgsql-bugs
>> so all of china uses CST, which is *NOT* CST as we know it here in North
>> America ;-/
>
> Yeah, it's going to be difficult to do much about this stuff with the
> current approach of a hardwired table of zone names.  There are other
> unresolved conflicts (IST is one I think).

Yeah, its a maze of twisty little passages.

I just fired off a suggestion to the DBAs and SQL developers on my team that
everything should use RFC822 style time,

    $ date -R
    Wed, 25 Aug 2004 19:43:22 -0700

and be done with it.  I haven't had a chance to look at the Java/JDBC code
which triggered the SGT bug in Singapore yet.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1231: Probelm with transactions in stored code.
Следующее
От: Ingo Schellhammer
Дата:
Сообщение: MOVE FIRST does not work in PL/pgSQL on refcursor