[openstreetmap/openstreetmap-website] Switch to TIMESTAMP WITH TIME ZONE for current_* tables (#375)

Andy Allan notifications at github.com
Wed Nov 21 11:01:50 UTC 2018

@pnorman exactly. The only reason to use it is for events that you want to happen in local time. So you could store an event "worldwide morning yoga sessions" at "2018-11-21T0900" `timestamp without timezone` meaning that it happens 38 times, or store "I want to wake up at 8am" as `timestamp without timezone` so that it happens at 8am in the winter and 8am at the summer. But for anything else, it's the wrong column type.

I really do think this is all a misinterpretation based on what people *think* the column types mean, based on the names of the types, rather than what they *actually* mean. I can understand the misinterpretation completely, it's not clearly expressed.

You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181121/89813921/attachment.html>

More information about the rails-dev mailing list