Guest User

Untitled

a guest
Dec 13th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. db.getCollection('people').find({
  2. date: {
  3. $gte: ISODate("2017-04-24T14:04:34.447Z")
  4. }
  5. },
  6. {
  7. _id: 0,
  8. age: 0,
  9.  
  10. }
  11. );
  12.  
  13. /* 1 */
  14. {
  15. "user_id" : "bcd020",
  16. "status" : "D",
  17. "date" : ISODate("2017-04-24T14:04:34.447Z")
  18. }
  19.  
  20. /* 2 */
  21. {
  22. "user_id" : "bcd021",
  23. "status" : "D",
  24. "date" : ISODate("2017-04-24T14:04:34.447Z")
  25. }
  26.  
  27. /* 1 */
  28. {
  29. "user_id" : "bcd020",
  30. "status" : "D",
  31. "date" : 2017-04-24 14:04:34
  32. }
  33.  
  34. /* 2 */
  35. {
  36. "user_id" : "bcd021",
  37. "status" : "D",
  38. "date" : 2017-04-24 14:04:34
  39. }
  40.  
  41. db.getCollection('people').aggregate([
  42. {
  43. $project:{
  44. datetime: {$dateToString: {format: "%G-%m-%d %H:%M:%S",date: "$datetime"}},
  45. age : 1
  46. }
  47. }
  48. ]);
Add Comment
Please, Sign In to add comment