How to insert a document with date in mongo?

Question

We are trying to insert a document with the current date as it's field. We are writing in java using eclipse plugin for mongodb. We want to execute the Date() command of mongo to get the date from mongo and not from java.

How can I execute this mongo query?

db.example.insert({"date":new Date()})

I found this question in a previews question but the answer was not helpful

Link

possible duplicate of [Best way to store date/time in mongodb](http://stackoverflow.com/questions/3778428/best-way-to-store-date-time-in-mongodb) — Alexandre Santos, Jun 30 '14 at 06:02
"eclipse plugin for mongodb" gives many different google hits. Could you narrow it down to a particular product? — Joachim Isaksson, Jun 30 '14 at 06:12
This question hasn't been solved yet. I was unable to achieve the same using java using any of the solutions below — chaitra.kear, Nov 21 '19 at 14:01

Neil Lunn · Accepted Answer · 2014-06-30T07:13:58.407

The standard driver takes java.util.date types and serializes as BSON dates. So with a collection object to "example"

Date now = new Date();

BasicDBObject timeNow = new BasicDBObject("date", now);
example.insert(timeNow);

If you are looking for a way to use the "server" time in operations, there is the $currentDate operator, but this works with "updates", so you would want an "upsert" operation:

 BasicDBObject query = new BasicDBObect();
 BasicDBObject update = new BasicDBObject("$currentDate",
     new BasicDBObject("date", true)
 );

 example.update(query,update,true,false);

Since that actually is an update statement, you need to be careful that you are not actually matching any documents if you intend this to be an insert only. So it would be best to make sure your "query" contains unique information, such as a newly generated _id or something equally unique.

This takes the date from the current working machine. Let's say the mongo is running on another server, and there is a small time differential, I want to display the date in the other machine, so I could see the difference even if it's a minute or so — itaied, Jun 30 '14 at 06:21
@Candroid You really should be making sure the times are synchronized, but there is a way to use the server time. — Neil Lunn, Jun 30 '14 at 06:35

score 11 · Answer 2 · answered Mar 23 '16 at 14:24

11

You can do it trying something like this:

db.example.insert({"date":ISODate("2016-03-03T08:00:00.000")});

answered Mar 23 '16 at 14:24

maikelsperandio

181
1
6

If you write `ISODate()` that field will be the current (on insert) datetime. – totymedli Aug 13 '17 at 19:46
which jar provide the ISODate() class – Nicksxs Sep 27 '19 at 07:21
1

@Nicksxs : I think this should be for node.js/shell or someother, but not for java code.. – whoami - fakeFaceTrueSoul Nov 21 '19 at 16:40

score 3 · Answer 3 · answered Jun 30 '14 at 06:02

3

Use this:

db.example.insert({"date":new Date(Date.now())});

answered Jun 30 '14 at 06:02

Devesh Kumar

1,009
1
17
29

2

I need to write it in java. How can I write this in java eclipse with mongo plugin? I tried using the 'command' but it didn't work – itaied Jun 30 '14 at 06:07
1

Could you explain your answer a bit? – Qix - MONICA WAS MISTREATED Jun 30 '14 at 06:35
2

The command you wrote is written for mongo shell. I want to execute this command in java language, so my question is how to do it? What is the right syntax? – itaied Jun 30 '14 at 07:11
Mongo documentation gives the standard way to insert date. http://docs.mongodb.org/getting-started/java/insert/ – Anandhakumar Subramaniam Sep 05 '15 at 15:29
The documentation does not solve this problem. Has anyone done this in java please – chaitra.kear Nov 21 '19 at 14:11
I think this should be for node.js/shell or someother, but not for java code.. – whoami - fakeFaceTrueSoul Nov 21 '19 at 16:42

score 1 · Answer 4 · answered Jun 05 '22 at 07:53

There is a key difference I noted when using Date() as follows.

{ dateWhenCreated : Date() }

vs

{ dateWhenCreated : new Date() }

Notice the "new" keyword in the second usage. Whereas the first usage loads the data "as a string", the second one loads date as a field with date data type.

This might impact your sorting capability - dates stored as strings don't get sorted the same way as dates stored as dates.

Per the mongodb documentation here

How to insert a document with date in mongo?

4 Answers4

Linked

Related