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

Andy Allan notifications at github.com
Wed Nov 21 12:22:47 UTC 2018

> My only remaining concern is that timestamp constants are always treated as `without timezone` unless explicitly cast which might cause an issue if somebody had a non-UTC default timezone?

Do we use timestamp constants anywhere? I'm guessing not in our rails code, but perhaps in other apps? If so, they could be re-written to be a `timestampz` e.g. `select ('2017-01-01 00:00:00' at time zone 'utc')::timestamptz`

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/eaa4d3cd/attachment.html>

More information about the rails-dev mailing list