Timeline for answer to Why does PostgreSQL interpret numeric UTC offset as POSIX and not ISO-8601? by Erwin Brandstetter
Current License: CC BY-SA 4.0
Post Revisions
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 19, 2024 at 2:21 | comment | added | Ryan |
The docs definitely appear to be incorrect. SET TIME ZONE '-7' sets ISO -7 (East of UTC), not +7 (West of UTC) as claimed. Meanwhile SET TIME ZONE '-07:00' is the opposite, it's ISO +7 (West of UTC).
|
|
| Mar 27, 2022 at 22:34 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
links
|
| Aug 27, 2018 at 8:20 | comment | added | dwelle |
so '+02:00' is treated as POSIX, but why is 'PST8PDT' treated as ISO (yielding negative, west-of-Greenwich offset -07:00:00), and most importantly, why is -7 treated as ISO, too, despite docs saying numbers are treated as POSIX (see my addendum from yesterday)? Or does the "Timezone settings given as numbers or intervals are internally translated to POSIX timezone syntax" only refer to output of SHOW TIME ZONE, and not how they are parsed/interpreted in the first place?
|
|
| Aug 27, 2018 at 4:10 | comment | added | Erwin Brandstetter |
@Dwelle: Right, I haddn't addressed your case of '+02:00'. I added some more.
|
|
| Aug 27, 2018 at 4:09 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
adapt to feedback
|
| Aug 26, 2018 at 17:34 | comment | added | dwelle | Thanks, but I'm somewhat still confused (if not more). Edited the question with more elaboration below the fold. | |
| Aug 26, 2018 at 15:09 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
added 59 characters in body
|
| Aug 26, 2018 at 15:00 | history | answered | Erwin Brandstetter | CC BY-SA 4.0 |