3 ms·
Am I the only one who thinks postgresql’s timestamp and timestamptz types are incredibly stupid? I just want to either save a local date and time, or an utc ti
by tobyhinloopen 3y ago
Am I the only one who thinks postgresql’s timestamp and timestamptz types are incredibly stupid?
I just want to either save a local date and time, or an utc timestamp. Postgresql’s timestamp(tz) types do neither and both at the same time.
- claytonjy 3y agoI've avoided `timestamp` and haven't needed localized times stored in the DB, but in what way is `timestamptz` not exactly the utc timestamp you expect?
- tobyhinloopen 3y agoIt converts the timezone automatically, which I do not want