How to read date (Timestamp) from MongoDB using Java

Question

Am trying to read date field from MongoDB in below format

Formate: YYYY-MM-dd HH:mm:ss.SSSSSS

2017-01-23-10.46.07.812000 - DB2
2017-01-23T16:46:07.812Z   - Stored in MongoDB (While viewing from GUI tool)
Mon Jan 23 22:16:07 IST 2017 - Result/Reading from MongoDB

// Formatter for the input date
final DateTimeFormatter inputFormat = DateTimeFormatter.ofPattern("EEE MMM dd HH:mm:ss zzz yyyy");
final ZonedDateTime dateFiledParsed = ZonedDateTime.parse(dateFiled.toString(), inputFormat);
final DateTimeFormatter outputFormat3 = DateTimeFormatter.ofPattern("YYYY-MM-dd HH:mm:ss.SSSSSS");
System.out.println(outputFormat3.format(publicationDateParsed));

Result: 2017-01-23 22:16:07.000000

In the result 2017-01-23 22:16:07.000000, instead of 000 it should be the 812 (Original value: 2017-01-23-10.46.07.812000)

Note: Using MongoDB Java driver 3.4.

Thank you in advance!

Bharathi

If it's actually a BSON Date ( which means it appears as `ISODate` when viewed in the `mongo` shell ) then anything that resolves to `java.util.Date` is the expected input format for queries. If you are sending any other format then it will not be a match. Also note to use UTC values instead of local times unless you understand the conversion process. — Neil Lunn, Jul 25 '17 at 07:03
What is `dateFiled` or the string output of `dateFiled.toString()`? — Seelenvirtuose, Jul 25 '17 at 07:15
@Seelenvirtuose - dateFiled is "Date dateFiled = "some date" — Bharathiraja S, Jul 25 '17 at 12:40
`Date` and `Timestamp` are two very different types in MongoDB, according to [the documentation](https://www.prisma.io/dataguide/mongodb/working-with-dates#the-mongodb-date-and-timestamp-types). I suggest you edit the Question to clarify which one you intend. — Basil Bourque, Mar 26 '23 at 00:39

score 5 · Accepted Answer · answered Jul 26 '17 at 04:20

You can use Java's SimpleDateFormat to format the date accordingly. For example, assuming you inserted the date in MongoDB using the proper ISODate type:

> db.test.find()
{
  "_id": ObjectId("597813a12dbe1d773beb11d2"),
  "date": ISODate("2017-01-23T16:46:07.812Z")
}

This code prints the correct date:

Document doc = collection.find().first();
Date date = doc.getDate("date");
SimpleDateFormat formattedDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
formattedDate.setTimeZone(TimeZone.getTimeZone("UTC"));
System.out.println(formattedDate.format(date));

Output is:

2017-01-23 16:46:07.812

Thanks a lot! Its woks as expected – Bharathiraja S Jul 26 '17 at 15:48 — Bharathiraja S, Jul 26 '17 at 15:48
how can i do this when working with dozer mapper – Youssef Boudaya Jul 12 '21 at 10:30 — Youssef Boudaya, Jul 12 '21 at 10:30

score 0 · Answer 2 · edited Jan 13 '22 at 14:28

In my case worked the next code, when passing a date to MongoDb:

SimpleDateFormat dateFormat= new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
dateFormat.setTimeZone(TimeZone.getTimeZone("GMT"));
System.out.println(dateFormat.format(date));

When retrieving it:

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS");
dateFormat.setTimeZone(TimeZone.getTimeZone("UTC"));
System.out.println(dateFormat.format(date));

score 0 · Answer 3 · answered Feb 15 '22 at 16:38

this 2 methods will match mongo's date format (util.Date in java)

public static String convertToString(Date date) {
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS");
    dateFormat.setTimeZone(TimeZone.getTimeZone(zone));
    return dateFormat.format(date);
}

public static Date convertToDate(String strDate) {
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS");
    dateFormat.setTimeZone(TimeZone.getTimeZone(zone));
    Date parsedDate = null;
    try {
        parsedDate = dateFormat.parse(strDate);
    } catch (ParseException e) {
        log.error(e.getMessage());
    }
    return parsedDate;

}

How to read date (Timestamp) from MongoDB using Java

3 Answers3

Linked