Dates not working in New Zealand about query-to-mongo HOT 2 CLOSED

According to MDM a Date is the number of milliseconds since January 1, 1970, 00:00:00 UTC.

However Date.parse (called by new Date(s)) has changed with respect to date-times without a specified time zone. In earlier versions, it defaulted to UTC. In ECMAScript 2015 it now defaults to the local time one!

Current best practice is to store dates relative to UTC in the database. So should we make this the default for parsing?

I propose adding a dateParse property to the options. It can have following values and defaults to utc:

• none - do not parse dates
• utc - assume UTC if time zone is not specified
• local - assume local time zone if time zone is not specified
• +hh:mm or '-hh:mm` - assume this offset from UTC if time zone is not specified

from query-to-mongo.

Ok after further investigation, I noticed that the regex for date/time requires a time zone offset. So, new Date(string) is behaving as the code expects.

The tests are wrong. They should be using new Date(Date.UTC(...)) instead of calling the setUTCxxx methods.

from query-to-mongo.