Option to show date in local timezone
Currently MongoDB is storing date and time in UTC - which is good and should be that way.
However, from the presentation (either via Compass/Shell), there should be a way to show the date and time based on locale time zone settings or an option to switch from UTC to local time zone.
So for people who consume data right from MongoDB, they don't get confused with the data differences between UTC and their local time zone.
3
votes
Raga Kuswardhono
shared this idea
-
AdminMassimiliano (Admin, MongoDB) commented
How would you expect that to work?
If it's just about displaying in your local time zone, in mongosh you could do something like in the screenshot below, by taking advantage of JS' Date object.