5 ms·
Why is this correct take being downvoted? Add consistency to your codebase by saving all timestamps in UTC. Edited: Storage size is the same.
by djrobstep 8y ago
Why is this correct take being downvoted?
Add consistency to your codebase by saving all timestamps in UTC.
Edited: Storage size is the same.
- grzm 8y agoThere's no difference in storage between timestamp and timestamptz in PostgreSQL. Both are 8 bytes.
- jeltz 8y agoI downnvoted because it is dangerous advice. If you use timestamp in PostgreSQL rather than timestamptz you will in run into even more time related bugs due to misusing PostgreSQL's data types, for example it will make AT TIME ZONE counterinutitve.