| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bharanee Rathna <deepfryed(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: ISO8601 vs POSIX offset clarification |
| Date: | 2017-12-04 02:55:53 |
| Message-ID: | 21940.1512356153@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bharanee Rathna <deepfryed(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bharanee Rathna | 2017-12-04 02:59:11 | Re: ISO8601 vs POSIX offset clarification |
| Previous Message | Bharanee Rathna | 2017-12-04 02:39:43 | ISO8601 vs POSIX offset clarification |