Currently Mendix stores all datetimes in DB in UTC timezone. When we want to transfer our data to a dataware house, we have to calculate each datetimes as locale timezones while moving the data. Our users are from only one country, and so reporting team and report viewers expect to see locale dates in reports. There lots of datetime attributes in a single application and making this calculation for each of them is very error prone, because it is possible to miss some of them, or any newly added ones.
I think database storage timezone should not be hard coded, instead it should be configurable for the application. Same multi timezone and daylight saving time functionalities can be kept as is it, the only thing that needs to be changed is to use configured timezone instead of hard coded UTC.