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

mmd notifications at github.com
Wed Nov 21 14:38:29 UTC 2018


The "Z" (zulu) character in the timestamp string implies that all timestamps should be returned in UTC-0, no matter what time zone the server runs in. 

I also remember seeing some issues when populating the database via osmosis from a UTC+3 terminal (see this year's GSoC project: https://github.com/osmlab/yalcha/issues/11). This ended up creating wrong timestamps all over the place. Not sure, if this behaviour would be any different with osmosis and `timestamp with timezone`.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/375#issuecomment-440684567
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181121/b53a7750/attachment.html>


More information about the rails-dev mailing list