core: ensure all db timestamp columns have a time zone.

(cherry picked from commit 159d81c519c3686455c392dccf236d7939ee74a7)