Re: BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'
Дата
Msg-id 17858.1141852545@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'  ("Alexander Pivovarov" <apivovarov@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
"Alexander Pivovarov" <apivovarov@gmail.com> writes:
> # select '05:04 GMT+3'::time with time zone;
>    timetz
> -------------
>  05:04:00-03
> (1 row)

This isn't a bug; it's expected.  The "GMT+n" syntax is defined by a
different standard than the one we follow for timestamp output, and
the two standards don't agree about sign.  It's unfortunate but there's
not a lot we can do about it.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2307: Buckup and sequences in DEFAULT part
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: BUG #2308: pg_dump -a does not respect referential dependencies