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.
Raga Kuswardhono
shared this idea
-
Silver
commented
Hi Massimiliano,
You provide some workaround to translate UTC to local timezone, that mean user need to add .map(***) into each find() command. If user forget, they will need to translate it by themself. It's not convenience for user.
-
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.
