[pg] use proper DATE type for day column
experimental mysql to postgresql migration