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

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

From
"Alexander Pivovarov"
Date:
The following bug has been logged online:

Bug reference:      2304
Logged by:          Alexander Pivovarov
Email address:      apivovarov@gmail.com
PostgreSQL version: 8.1.3
Operating system:   FreeBSD 6.1
Description:        Time zone bug:  '05:04 GMT+3'  processing as  '05:04:00
-03'
Details:

# select '05:04 GMT+3'::time with time zone;
   timetz
-------------
 05:04:00-03
(1 row)
"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