News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.