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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander Pivovarov" <apivovarov(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'
Date: 2006-03-08 21:15:45
Message-ID: 17858.1141852545@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alexander Pivovarov" <apivovarov(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jim Nasby 2006-03-08 22:02:01 Re: BUG #2308: pg_dump -a does not respect referential dependencies
Previous Message Tom Lane 2006-03-08 21:10:49 Re: BUG #2307: Buckup and sequences in DEFAULT part