3 ms·
Righto. Solicit a time-zone preference from each user, using the zoneinfo naming system ('Asia/Kolkata' or 'America/Indiana/Vincennes') Then accept times from,
by OliverJones 8y ago
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.