JavaScript’s Date object supports the ISO date format, so as long as you have access to the date string, you can do something like this: > foo = new Date(“2012-07-14T01:00:00+01:00”) Sat, 14 Jul 2012 00:00:00 GMT > foo.toTimeString() ’17:00:00 GMT-0700 (MST)’ If you want the time string without the seconds and the time zone then … Read more
You just need to store an instance of datetime.datetime. Inserting from the python shell: >>> c.test.test.insert({‘date’: datetime.datetime.utcnow()}) ObjectId(‘4e8b388367d5bd2de0000000′) >>> c.test.test.find_one() {u’date’: datetime.datetime(2011, 10, 4, 16, 46, 59, 786000), u’_id’: ObjectId(‘4e8b388367d5bd2de0000000’)} Querying in the mongo shell: > db.test.findOne() { “_id” : ObjectId(“4e8b388367d5bd2de0000000”), “date” : ISODate(“2011-10-04T16:46:59.786Z”) }
Try this var date = new Date(“11/21/1987 16:00:00”); // some mock date var milliseconds = date.getTime(); // This will return you the number of milliseconds // elapsed from January 1, 1970 // if your date is less than that date, the value will be negative console.log(milliseconds); EDIT You’ve provided an ISO date. It is also … Read more
There is no need for a library, simply set the seconds and milliseconds to zero and use the built–in toISOString method: var d = new Date(); d.setSeconds(0,0); document.write(d.toISOString()); Note: toISOString is not supported by IE 8 and lower, there is a pollyfil on MDN.
You can use new Date(‘2013-12-12T16:00:00.000Z’) in node.js; new is a must, because Date() is already use to return date string. ISODate is concepted in mongodb, you can use it in mongodb console, but it can be different for different programming language.
Although $date is a part of MongoDB Extended JSON and that’s what you get as default with mongoexport, I don’t think you can really use it as a part of the query. If try exact search with $date like below: db.foo.find({dt: {“$date”: “2012-01-01T15:00:00.000Z”}}) you’ll get the error: error: { “$err” : “invalid operator: $date”, “code” … Read more