3 ms·
The discussion was about storing a timestamp as UTC, plus the timezone the time was in originally as a second field. Postgres has timezone aware datetime field
by Scarblac 2y ago
The discussion was about storing a timestamp as UTC, plus the timezone the time was in originally as a second field.
Postgres has timezone aware datetime fields, that translate incoming times to UTC, and outgoing to a configured timezone. So it doesnt store what timezone the time was in originally.
The claim was that the docs explain why not, but they don't.