MongoDB Date Query

Introduction to MongoDB Date Query

MongoDB date query returns the date either as string or date object, date query will return the current date as string in the mongo shell. MongoDB date will return the current date as a date object, mongo shell will wrap the date object with isolate helper in MongoDB. We can specify the particular date by passing the date as ISO-8601 date string, this string is used with the range as 0 to 9999 to the new date() function in MongoDB.

How does Date Query work in MongoDB?

• We can use date () command to get date as string in query without new keyword or MongoDB shell.
• While creating a new date object we can specify the date object as follows.
• Date query in MongoDB will internally store 64 bit integer value which was representing the number of milliseconds, it is used by UNIX from 1 Jan 1970.
• MongoDB date object store 64 bit, but it will not store all database versions and operations that it will support 64 bit.
• We can use date as string, we can also use date as method and object in MongoDB.
• In MongoDB we can convert the date object into the string into specified format. There are different operator available for date to string in MongoDB.
• There are two ways available in MongoDB to store date time they are new Date () and new ISODate ().
• In first approach we can use the date object in MongoDB like java script. The date object or method is the best method to store the date or time in MongoDB.
• In the second approach we can use ISODate method to store date or time in MongoDB.
• MongoDB does not support the date without time zone format. The alternate way to store date without time zone is to use two types of log representation.
• First is millisecond and second is (<YYYY-mm-dd HH:MM:ss>). These are the ways that are available in MongoDB to store the date without time zone in MongoDB.
• We have used ISODate function in MongoDB this is used to build the native java script function.
• ISODate in MongoDB provides the convenient way to represent the date in MongoDB.
• String date format is used to store string in date format. This is used to store date as simple string in human readable format.
• While storing date in string format it is very easy to display, while storing date in string format there is no need to processing of using the same.
• Also while storing date in string format it is easy to convert it into any other platform or format. But it is very difficult to determine date format while storing it into string format.

Various Date Format in MongoDB

Given below are the date format and each returns a resulting ISODate instance:

• new Date (<milliseconds>)
• new Date (<YYYY-mm-dd THH:MM:ss>)
• new Date (<YYYY-mm-dd>)
• new Date(“<YYYY-mm-ddTHH:MM:ssZ>”)

1. new Date (<milliseconds>)

• Milliseconds is an integer and it specifies the number of milliseconds. Milliseconds defines integer value which was used date format in MongoDB.
• Milliseconds will convert date into standard date format.
• Below example shows that converts milliseconds into date format. In below example we have display two examples. In first example we have used 1234567890 milliseconds output of this milliseconds is 1970-01-15 and in second example we have used 0987654321 milliseconds output of this milliseconds is 1970-01-12.

Example:

Code:

new Date(1234567890)


new Date(0987654321)

Output:

2. new Date (<YYYY-mm-dd THH:MM:ss>)

• This format defines the year, month and date in full format, it will also show the hour, minute and second in full format.
• In below example we have used date as (“2020-05-15T12:05:45”) and output of using this date is (“2020-05-15T06:35:45Z”).

Example:

Code:

new Date("2020-05-15T12:05:45")

Output:

3. new Date (<YYYY-mm-dd>)

• This format is defined as year, month and date in full format.
• In below example we have used date as (“2020-05-15”) and output of using this date is (“2020-05-15T00:00:00Z”).

Example:

Code:

new Date("2020-05-15")

Output:

4. new Date(“<YYYY-mm-ddTHH:MM:ssZ>”)

• This format defines the year, month and date in full format, it also shows the hour, minute and second in full format.
• In below example we have used date as (“2020-05-15T12:05:45Z”) and output of using this date is (“2020-05-15T06:35:45Z”).

Example:

Code:

new Date("2020-05-15T12:05:45Z")

Output:

Examples of MongoDB Date Query

Given below are the examples of MongoDB Date Query:

Example #1

To store date using new Date () format in MongoDB.

In below example we have we have used new Date () object in MongoDB. We have used test collection while using date object in MongoDB.

Code:

db.test.insertOne ({"Id":"1","Date”: new Date()});
db.test.find ()

Output:

Example #2

To store date using new ISODate () format in MongoDB.

In below example we have we have used new ISODate () object in MongoDB. We have used test1 collection while using date object in MongoDB.

Code:

db.test1.insertOne ({"Id":"1","Date":new ISODate()});
db.test1.find ()

Output:

Example #3

Use Date () method in MongoDB.

In below example we have used date function.

Code:

Date ()

Output:

Example #4

Use new Date () method in MongoDB.

In below example we have used date function.

Code:

new Date ()

Output:

Conclusion

Date query is used to return the date as query or string. Basically there are two ways available to store date i.e. date () and ISODate (). String date format is used to store sting into date format, while storing date into string format it’s very easy to display.

This is a guide to MongoDB Date Query. Here we discuss the introduction to MongoDB Date Query, how does date query work with various date format in MongoDB and examples. You may also have a look at the following articles to learn more –

1. MongoDB Data Types
2. MongoDB Geospatial
3. MongoDB MapReduce
4. MongoDB Limit()