TL;DR: I want to have support for a datetime field which shows the users local time.
As an ISV we have customers all over the world. This brings some issues with datetime values. We currently save all datetime values as UTC 0 and use a helper function to convert it to the customer local time. This has the disadvantage this needs to be set up for each customer and there is currently no support for customer with offices in multiple timezones. That could be fixed by saving the time zone per user / office, but that introduces yet another setting and introduces complexity (which we don't want). In my opinion the database should not be responsible for displaying the correct time, the client should.
I would suggest that there is some kind of option that always converts a datetime utc0 value to the local time of the users device. Then it's not needed to store company / user information about it's region in a database or IAM.
For us this applies on the webgui, the Universal GUI and the reports generated with DevExpress.
