SEO

#1 (**permalink**) 04-10-2008, 09:48 AM

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)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#2 (**permalink**) 04-10-2008, 09:48 AM

"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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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