Mongodb可参考的查询
2021/10/10 16:54:43
本文主要是介绍Mongodb可参考的查询,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
-
条件AND
1 db.csr_log_info.find({$and:[{enterTime :{$regex:/2021-08-31 18:01/}},{enterTime :{$ne:"2021-08-31 18:01:56"}}]}).pretty();
-
聚合、日期格式化
1 db.csr_log_info.AGGREGATE ( 2 [ 3 { 4 $project :{ createStr :{ $dateToString :{ format : "%Y-%m-%d %H:%M:%S",date :{ $ ADD :[ new Date( 28800000 ),"$createDate" ]}}}, 5 createStrS :{ $dateToString :{ format : "%Y-%m-%d %H:%M:%S",date :{ $ ADD :[ new Date( 0 ),"$createDate" ]}}},enterTime : 1,username : 1 6 } 7 }, 8 { 9 $LIMIT : 1 10 } 11 ] 12 );
-
聚合
1 db.pt_log_info.AGGREGATE ( 2 [ 3 { 4 $project :{ createStr :{ $dateToString :{ format : "%Y-%m-%d %H:%M:%S",date :{ $ ADD :[ new Date( 28800000 ),"$createDate" ]}}},createStrS :{ $dateToString :{ format : "%Y-%m-%d %H:%M:%S",date :{ $ ADD :[ new Date( 0 ),"$createDate" ]}}},enterTime : 1,username : 1,createYM :{ $dateToString :{ format : "%Y-%m-%d",date :{ $ ADD :[ new Date( 28800000 ),"$createDate" ]}}}} 5 }, 6 { 7 $MATCH :{ createStr :{ $gte : "2021-09-19",$lt : "2021-09-23" }} 8 }, 9 { 10 $GROUP :{ _id : "$createYM",count_V :{ $ sum : 1 }} 11 }, 12 { 13 $sort:{_id:1} 14 } 15 ] 16 );
这篇关于Mongodb可参考的查询的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-26解决google chrome helper 内存占用较高!
- 2024-04-01got an unexpected keyword argument
- 2024-03-30维多利亚的秘密 golang入坑系统
- 2024-03-29mongodb sort by date
- 2024-03-29go swagger
- 2024-03-25mongodb cdc
- 2024-03-25how to use go in vscode
- 2024-03-22mongooseserverselectionerror: connect econnrefused ::1:27017
- 2024-03-21pymongo insert_many
- 2024-03-18projection mongodb