fix(core): Use consistent timezone-aware timestamps in postgres

fix(core): Use consistent timezone-aware timestamps in postgres #505