db: make observations.observed_at column timezone-aware