I would like to know if any option to set timezone on Mongo DB configuration. We are about the following fact still looking for some workaround if possible / feasible.
The MongoDB date type is not time zone-aware, so the correct way of storing dates is to always normalise them to UTC for storage. MongoDB stores date & time in ISO Date which is UTC/GMT.
In Mongo code level it uses BSON date & time format which is a 64-bit integer that represents the number of milliseconds since the Unix epoch (Jan 1, 1970). This results in a representable date range of about 290 million years into the past and future.