Insert field with $currentDate to MongoDB collection in Meteor

Question

Not sure how to use $currentDate when inserting a document into a MongoDB collection in Meteor.

Can this only be used in an update, not an insert? Would seem strange, but I don't see an alternative (other than using new Date instead).

Example

Stuff.insert({     owner: Meteor.userId(),    createdAt: ..., // how to create this field with $currentDate ?    theStuff: "Some of the good stuff" }) 

Notes / Thoughts / TL,DR

• Fields can't start with $ operators or, as far as I know, curly braces {}.
• What's the point of having an operator that only works with updates, if that's indeed the case?
• Why/when is $currentDate better than new Date?
• One nice thing, if using Moment.js esp, is that $currentDate is entered in ISO 8601 format.
• Is the answer to do some kind of upsert from the start? If so, could this have unintended consequences?

Answer 1

What's the point of having an operator that only works with updates, if that's indeed the case?

$currentDate is an update operator thus you can't use it with the collection.insert method. But when upsert is true it will create a new document when no document matches the query criteria. MongoDB operators tend to follow the Unix philosophy

Do One Thing and Do It Well

So each operator should perform only one task.

Why/when is $currentDate better than new Date?

First I would like to mention that new Date is a JavaScript Date instance.

$currentDate and new Date can be used when you want to update the value of a field to current date but with new Date you need to use another update operator for it to work. For example:

• Using new Date

  db.collection.update({ "name": "bar" }, { "$set": { "date": new Date() }}) 

• Using $currentDate

  db.collection.update({ "name": "bar"},      { "$currentDate": { "date": { "$type": date }}} ) 

Unlike $currentDate, new Date can be use with the insert method and value can be set to a particular if Date is call with more than on argument.

Answer 2

You can retrieve timestamp from autogenerated "_id" that is created within insert operation.

http://api.mongodb.com/java/current/org/bson/types/ObjectId.html

Just use the method : ObjectId.getTimestamp().

Timestamp granularity is in seconds.