Timeline for answer to How to compare timestamps with different time zones? by Erwin Brandstetter
Current License: CC BY-SA 4.0
Post Revisions
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 9, 2018 at 21:55 | vote | accept | 7cart project | ||
| Sep 8, 2018 at 14:39 | comment | added | Erwin Brandstetter | @dmytrocx75: To your 1st comment: Sounds about right. Not sure it was the "main thing", though. That would be: Timestamp and timezone handling depends on many things, is complex and may be confusing - currently more confusing than necessary. Dumb people have been allowed to set up dumb rules and standards. We have the misguided POSIX standard above and there are the moronic DST rules (which the EU might hopefully abolish soon) and other political nonsense complicating things. | |
| Sep 8, 2018 at 12:53 | comment | added | 7cart project | Thank you! So the main thing you're telling me is: when I do timestamp BETWEEN timestamptz1 and timestamptz2 I actually do BETWEEN (timestamp1+offset1) AND (timestamp2+offcet2), because internally timestamps are stored and processed in UTC. Am I getting it right? | |
| Sep 8, 2018 at 11:56 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
deleted 60 characters in body
|
| Sep 8, 2018 at 11:50 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
add demo
|
| Sep 8, 2018 at 11:13 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
added 601 characters in body
|
| Sep 8, 2018 at 10:53 | history | answered | Erwin Brandstetter | CC BY-SA 4.0 |