Re:Timestamps and Time Zones in PostgreSQL (2016)
by OliverJones on Sunday March 31, 2019 @09:38AM
(#19535511)
Righto. Solicit a time-zone preference from each user, using the zoneinfo naming system ('Asia/Kolkata' or 'America/Indiana/Vincennes') Then accept times from, and render times to, that user in their local time. DBMS timezone settings do a good job of that.
When users decline to give a preference, show them UTC until they get tired of it and give you a preference.
Finally, boycott Oracle's table server. It's horrible in this respect.
Finally, boycott Oracle's table server. It's horrible in this respect.