"Alexander Pivovarov" <apivovarov (AT) gmail (DOT) com> writes:
Quote:
# 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