We are using MongoDB 2.4.9 (64 bit) for Windows 7 SP1 (64 bit). When we run the query below, and we have someone from our collection with a date of birth before 1970, we get the exception "gmtime failed - your system does not support dates until 1970".
db.persons.aggregate({ $project: { date: { year: { $year: "$DateOfBirth" }, month: { $month: "$DateOfBirth" }, day: { $dayOfMonth: "$DateOfBirth" } } } })
I read in other threads that this is a known issue when starting MongoDB on some versions of Windows. Please note that our project cannot be deployed on a platform other than Microsoft.
mongodb mongodb-.net-driver
Nospheratus79
source share