Sorry I didn't mean for it to come out as a complaint, just that I am confused since the result of the SQL query was not what I expected. I expected +11:00 to be 11 hours east of UTC which wasn't the case.
On 4 December 2017 at 13:55, Tom Lane <t...@sss.pgh.pa.us> wrote: > Bharanee Rathna <deepfr...@gmail.com> writes: > > the documentation around how numeric offsets are parsed from strings is a > > bit confusing, are they supposed to be treated as ISO8601 or POSIX ? > > Our documentation about this says clearly that Postgres considers offsets > to be ISO (positive-east-of-Greenwich) everywhere except in POSIX-style > time zone names. > > > The Table 8-12. Time Zone Input section at > > https://www.postgresql.org/docs/9.3/static/datatype-datetime.html seems > to > > imply that numeric offsets would be treated as ISO8601. > > How do you read an entry such as > > -8:00 | ISO-8601 offset for PST > > as being in any way vague about which convention the "-8" is read in? > > regards, tom lane >
