javascript - Store date in MongoDB without considering the timezone

Question

Which is the best way to store a date in MongoDB without considering the timezone?

I try to explain the problem with an example:

Giuseppe in Italy created an invoce in date "December 15, 2014", when the system store this date, in MongoDB will be stored "2014-12-14T23:00:00.000Z".

John in UK read the invoice and see "December 14, 2014" as the invoice date.

Obviously this information is wrong becouse also Jhon should see "December 15, 2014" as the invoice date, how can I solve this problem?

Answer 1

Whole dates should not be placed in a Date object. Despite the name, Date represents a date and a time. If the value you're working with represents a whole date, rather than a specific time on that date, then you should store the value in another format.

Options are:

• A string in YYYY-MM-DD or YYYYMMDD format
• An integer number of whole days since some reference point.