What is the best way to store dates in MongoDB?

by

I’m actually in the process of converting a MongoDB database where dates are stored as proper Date() types to instead store them as strings in the form yyyy-mm-dd. Why, considering that every other answerer says that this is a horrible idea? Simply put, because of the neverending pain I’ve been suffering trying to work with dates in JavaScript, which has no (real) concept of timezones. I had been storing UTC dates in MongoDB, i.e. a Date() object with my desired date and the time set as midnight UTC, but it’s unexpectedly complicated and error-prone to get a user-submitted date correctly converted to that from whatever timezone they happen to be in. I’ve been struggling to get my JavaScript “whatever local timezone to UTC” code to work (and yes, I’m aware of Sugar.js and Moment.js) and I’ve decided that simple strings like the good old MySQL standard yyyy-mm-dd is the way to go, and I’ll parse into Date() objects as needed at runtime on the client side.

Incidentally, I’m also trying to sync this MongoDB database with a FileMaker database, which also has no concept of timezones. For me the simplicity of simply not storing time data, especially when it’s meaningless like UTC midnight, helps ensure less-buggy code even if I have to parse to and from the string dates now and then.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Authentication failure while trying to save to mongodb
  3. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  4. Converting string to date in mongodb
  5. Querying internal array size in MongoDB
  6. MongoDB wildcard in the key of a query
  7. How to create a DB for MongoDB container on start up?
  8. How to access a preexisting collection with Mongoose?
  9. How do I query for distinct values in Mongoose?
  10. MongoDB field order and document position change after update
  11. MongoDB Full and Partial Text Search
  12. How to query MongoDB to test if an item exists?
  13. Find duplicate records in MongoDB
  14. Working with special characters in a Mongo collection
  15. Mongo sort on a calculated condition
  16. MongoDB: output ‘id’ instead of ‘_id’
  17. MongoDB: Updating subdocument
  18. MongoDB $gt/$lt operators with prices stored as strings
  19. MongoDB: Calculate dwell time between every status value change
  20. How to export all collections in MongoDB?
  21. Couldn’t connect to server 127.0.0.1:27017
  22. Dealing with schema changes in Mongoose
  23. How to use mongoimport to import CSV files?
  24. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  25. How to access overall document count during arithmetic aggregation expression
  26. How to find min value in mongodb
  27. Does MongoDB support floating point types?
  28. How to deal with the timezone issue when storing dates in utc using mongod?
  29. Fuzzy Searching with Mongodb?
  30. Query for a field in an object in array with Mongo?

Leave a Comment