How to insert a MongoDB document with a timestamp from the database server

Question

In Oracle, I could simply do this:

INSERT INTO myTable VALUES ('someValue',SYSTIMESTAMP);

That would insert two values into myTable, and one of them would be a timestamp based-on the database server's time.

For MongoDB (via the Java driver) I've tried this:

myDoc.put("value","someValue");
myDoc.put("timestamp", new Date());
myCollection.insert(myDoc);

But that creates a timestamp based-on the client machine's time, not the database server's time.

Is there a way to have MongoDB apply a timestamp to a document based-on the the database server time?

score 8 · Accepted Answer · answered Feb 18 '15 at 11:06

8

A little late to the game - but the recent releases of mongodb have $currentDate.

answered Feb 18 '15 at 11:06

Shane Gannon

what to do if i want to insert a stored date/time value into mongodb in the mongodb-recognised date/timestamp format? – Nikhil VJ Jul 02 '20 at 04:36
1

You can use ISODate. – Shane Gannon Jul 02 '20 at 09:16

score 0 · Answer 2 · answered Feb 14 '21 at 18:00

0

Looks like you can get the server to generate a Timestamp on insert with db.test.insertOne( { ts: new Timestamp() } );. https://docs.mongodb.com/manual/reference/bson-types/#timestamps

answered Feb 14 '21 at 18:00

k force

Typescript complains about this `Expected 1-2 arguments, but got 0.` – forgetso Nov 01 '22 at 13:28

score -1 · Answer 3 · answered May 27 '12 at 06:12

-1

Use Morphia ORM tool for MongoDB

and for your problem hope lifecycle method of this is helpful.

i have getting result by using @Prepersist method

answered May 27 '12 at 06:12

Yogesh Prajapati

3 Answers3