Best way to store date/time in mongodb

by

The best way is to store native JavaScript Date objects, which map onto BSON native Date objects.

> db.test.insert({date: ISODate()})
> db.test.insert({date: new Date()})
> db.test.find()
{ "_id" : ObjectId("..."), "date" : ISODate("2014-02-10T10:50:42.389Z") }
{ "_id" : ObjectId("..."), "date" : ISODate("2014-02-10T10:50:57.240Z") }

The native type supports a whole range of useful methods out of the box, which you can use in your map-reduce jobs, for example.

If you need to, you can easily convert Date objects to and from Unix timestamps1), using the getTime() method and Date(milliseconds) constructor, respectively.

1) Strictly speaking, the Unix timestamp is measured in seconds. The JavaScript Date object measures in milliseconds since the Unix epoch.

More Related Contents:

  1. PHP 01/01/1970 Issues with Date Fields
  2. Daylight saving time and time zone best practices [closed]
  3. Find objects between two dates MongoDB
  4. How to convert java.util.Date to java.sql.Date?
  5. Incrementing a date in JavaScript
  6. Iterating through a range of dates in Python
  7. Check time difference in Javascript
  8. MySQL Query GROUP BY day / month / year
  9. Browsers, time zones, Chrome 67 Error (historic timezone changes)
  10. Javascript – get array of dates between 2 dates
  11. How to get the current time as datetime
  12. Check if string has date, any format
  13. AngularJS – convert dates in controller
  14. SQL Query to find the last day of the month
  15. Convert numpy.datetime64 to string object in python
  16. Calculate the number of weekdays between 2 dates in R
  17. Exception: can’t convert from BSON type EOO to Date
  18. How to transform currentTimeMillis to a readable date format? [duplicate]
  19. How to cast DATETIME as a DATE in mysql?
  20. Stop javascript Date function from changing timezone offset
  21. Java Best Practice for Date Manipulation/Storage for Geographically Diverse Users
  22. How do I convert an interval into a number of hours with postgres?
  23. Range.Find not making a difference between January and November (February and December) in VBA Excel
  24. Work with a time span in Javascript
  25. How do I convert a date/time to epoch time (unix time/seconds since 1970) in Perl?
  26. Converting to date in PHP from yyyymmdd format
  27. Subtracting a certain number of hours, days, months or years from date
  28. Convert decimal day to HH:MM
  29. How do I convert an ISO8601 date to another format in PHP?
  30. Round a POSIX date (POSIXct) with base R functionality

Leave a Comment