What is the syntax for Dates in MongoDB running on MongoLab?

json mongodb datetime bson mlab
SomethingOn picture SomethingOn · Nov 4, 2011 · Viewed 7.5k times · Source

Instead of ObjectId('82he921he982he82') its "_id":{"$oid":"82he921he982he82"} for object Ids, but I have no idea how to create a date value in a document on MongoLab :s

Answer

will picture will · Nov 4, 2011

If you are using one of the drivers, you create a date via that language's Date class. For instance, in Javascript (like Node.js) it would be 'new Date(11,11,11)'. If using the MongoLab REST API or admin UI you represent dates with this syntax: 

  { "$date": "2010-10-28T23:07:11Z" }

Related questions

Date query with ISODate in mongodb doesn't seem to work

I don't seem to be able to get even the most basic date query to work in MongoDB. With a document that looks something like this: { "_id" : "foobar/201310", "ap" : "foobar", "dt" : ISODate("2013-10-01T00:00:00.000Z"), "tl" : 375439 } And a query …

Read More
Mongoimport of json file

I have a json file consisting of about 2000 records. Each record which will correspond to a document in the mongo database is formatted as follows: {jobID:"2597401", account:"XXXXX", user:"YYYYY", pkgT:{"pgi/7.2-5":{libA:["libpgc.so"],flavor:["default"]}}, startEpoch:"1338497979", runTime:"1022", …

Read More
Dump Mongo Collection into JSON format

Is there any way to dump mongo collection into json format? Either on the shell or using java driver.I am looking for the one with best performance.

Read More