How to deal with the timezone issue when storing dates in utc using mongod?

by

Aside from the SERVER-6310 mentioned by Matt Johnson, one other workaround is to use the $project operator to add or subtract from the UTC time zone to “shift the time” into the correct local zone. Turns out you can add or subtract time in milliseconds.

For example, assuming I have a Date field called orderTime. I’d like to query for EDT. That is -4 hours from UTC. That’s 4 * 60 * 60 * 1000 milliseconds.

So I would then write the following projection to get day_ordered in local time for all my records:

db.table.aggregate( 
    { $project : { orderTimeLocal : { $subtract : [ "$orderTime", 14400000] } } },
    { $project : { day_ordered : { $dayOfYear : "$orderTimeLocal" } } })

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. MongoDB: Combine data from multiple collections into one..how?
  4. mongodb group values by multiple fields
  5. Find in Double Nested Array MongoDB
  6. MongoDB: count the number of items in an array
  7. Multiple join conditions using the $lookup operator
  8. Conditional $sum in MongoDB
  9. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  10. Get a count of total documents with MongoDB when using limit
  11. exclude fields in $lookup aggregation
  12. How to sum every fields in a sub document of MongoDB?
  13. Add some kind of row number to a mongodb aggregate command / pipeline
  14. Exception: can’t convert from BSON type EOO to Date
  15. MongoDB sort documents by array elements
  16. Mongodb Aggregation Framework: Does $group use index?
  17. MongoDB: how to parse date in 3.6 mongoDb version?
  18. convert iso date to timestamp in mongo query
  19. Using $slice operator to get last element of array
  20. Geospatial $near within current document field value
  21. Mongodb aggregation pipeline how to limit a group push
  22. MongoDB : aggregation framework : $match between fields
  23. Find documents whose array field contains at least n elements of a given array
  24. Generating a Structure for Aggregation
  25. MongoDB to Use Sharding with $lookup Aggregation Operator
  26. Export mongodb aggregation framework result to a new collection
  27. Mongodb, aggregate query with $lookup
  28. Return the last “true” value for each group
  29. MongoDB aggregate by field exists
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment