大家一定要注意下时间，时间要指定注入，别用mongodb自带的 new date了，他的时间是utc的时间，和咱们中国时区少8个小时。
当然你要是不觉得麻烦的话，可用python的pymongo库做一些时间的调整，但是还是麻烦。。。。 还是插入指定的时间把。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 |
> use xiaorui switched to db xiaorui > > db.xiaorui.test.insert({'good':1}) > db.xiaorui.test.insert({'good':2}) > db.xiaorui.test.insert({'good':3}) > db.xiaorui.test.find({}) { "_id" : ObjectId("536232595a87a26d8f721f9b"), "good" : 1 } { "_id" : ObjectId("5362325c5a87a26d8f721f9c"), "good" : 2 } { "_id" : ObjectId("5362325e5a87a26d8f721f9d"), "good" : 3 } > > > db.xiaorui.test.insert({'ltime':ISODate("2012-11-02 07:58:51")}) > > db.xiaorui.test.find({}) { "_id" : ObjectId("536232595a87a26d8f721f9b"), "good" : 1 } { "_id" : ObjectId("5362325c5a87a26d8f721f9c"), "good" : 2 } { "_id" : ObjectId("5362325e5a87a26d8f721f9d"), "good" : 3 } { "_id" : ObjectId("536232c15a87a26d8f721f9e"), "ltime" : ISODate("2012-11-02T07:58:51Z") } > > db.xiaorui.test.insert({'ltime':ISODate("2012-11-02 07:58:55")}) > db.xiaorui.test.find({}) { "_id" : ObjectId("536232595a87a26d8f721f9b"), "good" : 1 } { "_id" : ObjectId("5362325c5a87a26d8f721f9c"), "good" : 2 } { "_id" : ObjectId("5362325e5a87a26d8f721f9d"), "good" : 3 } { "_id" : ObjectId("536232c15a87a26d8f721f9e"), "ltime" : ISODate("2012-11-02T07:58:51Z") } { "_id" : ObjectId("536232cf5a87a26d8f721f9f"), "ltime" : ISODate("2012-11-02T07:58:55Z") } > > > db.xiaorui.test.insert({'ltime':ISODate("2012-11-03 07:58:55")}) > db.xiaorui.test.insert({'ltime':ISODate("2012-11-04 07:58:55")}) > db.xiaorui.test.insert({'ltime':ISODate("2012-11-05 07:58:55")}) > db.xiaorui.test.insert({'ltime':ISODate("2012-11-06 07:58:55")}) > db.xiaorui.test.find({}) { "_id" : ObjectId("536232595a87a26d8f721f9b"), "good" : 1 } { "_id" : ObjectId("5362325c5a87a26d8f721f9c"), "good" : 2 } { "_id" : ObjectId("5362325e5a87a26d8f721f9d"), "good" : 3 } { "_id" : ObjectId("536232c15a87a26d8f721f9e"), "ltime" : ISODate("2012-11-02T07:58:51Z") } { "_id" : ObjectId("536232cf5a87a26d8f721f9f"), "ltime" : ISODate("2012-11-02T07:58:55Z") } { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } > > > db.xiaorui.test.insert({'ltime':ISODate("2012-11-07 07:58:55")}) > db.xiaorui.test.insert({'ltime':ISODate("2012-11-08 07:58:55")}) > db.xiaorui.test.insert({'ltime':ISODate("2012-11-11 07:58:55")}) > > > > db.xiaorui.test.find({}) { "_id" : ObjectId("536232595a87a26d8f721f9b"), "good" : 1 } { "_id" : ObjectId("5362325c5a87a26d8f721f9c"), "good" : 2 } { "_id" : ObjectId("5362325e5a87a26d8f721f9d"), "good" : 3 } { "_id" : ObjectId("536232c15a87a26d8f721f9e"), "ltime" : ISODate("2012-11-02T07:58:51Z") } { "_id" : ObjectId("536232cf5a87a26d8f721f9f"), "ltime" : ISODate("2012-11-02T07:58:55Z") } { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-05")}}) { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-08")}}) { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-8")}}) { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } > > > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } > db.xiaorui.test.insert({'ltime':ISODate("20121112115822")}) > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } > > > > db.xiaorui.test.insert({'ltime':ISODate("20121114")}) > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } > db.xiaorui.test.insert({'ltime':ISODate("20121114 11:11:11")}) > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } { "_id" : ObjectId("536234385a87a26d8f721fa9"), "ltime" : ISODate("2012-11-14T11:11:11Z") } > db.xiaorui.test.insert({'ltime':new Date}) > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } { "_id" : ObjectId("536234385a87a26d8f721fa9"), "ltime" : ISODate("2012-11-14T11:11:11Z") } { "_id" : ObjectId("536234585a87a26d8f721faa"), "ltime" : ISODate("2014-05-01T11:47:36.144Z") } > > > > db.xiaorui.test.insert({'ltime':new}) Thu May 1 19:51:06.083 SyntaxError: Unexpected token } > db.xiaorui.test.insert({'ltime':new Date()}) > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } { "_id" : ObjectId("536234385a87a26d8f721fa9"), "ltime" : ISODate("2012-11-14T11:11:11Z") } { "_id" : ObjectId("536234585a87a26d8f721faa"), "ltime" : ISODate("2014-05-01T11:47:36.144Z") } { "_id" : ObjectId("536235365a87a26d8f721fab"), "ltime" : ISODate("2014-05-01T11:51:18.926Z") } > > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } { "_id" : ObjectId("536234385a87a26d8f721fa9"), "ltime" : ISODate("2012-11-14T11:11:11Z") } { "_id" : ObjectId("536234585a87a26d8f721faa"), "ltime" : ISODate("2014-05-01T11:47:36.144Z") } { "_id" : ObjectId("536235365a87a26d8f721fab"), "ltime" : ISODate("2014-05-01T11:51:18.926Z") } > db.xiaorui.test.insert({'ltime':new Date().toLocaleString()}) > db.xiaorui.test.insert({'ltime':ISODate("20140501 19:56:11")}) > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } { "_id" : ObjectId("536234385a87a26d8f721fa9"), "ltime" : ISODate("2012-11-14T11:11:11Z") } { "_id" : ObjectId("536234585a87a26d8f721faa"), "ltime" : ISODate("2014-05-01T11:47:36.144Z") } { "_id" : ObjectId("536235365a87a26d8f721fab"), "ltime" : ISODate("2014-05-01T11:51:18.926Z") } { "_id" : ObjectId("5362368c5a87a26d8f721faf"), "ltime" : ISODate("2014-05-01T19:56:11Z") } > db.xiaorui.test.find({'ltime':{$gt:new Date("2012-11-3")}}) { "_id" : ObjectId("536232e05a87a26d8f721fa0"), "ltime" : ISODate("2012-11-03T07:58:55Z") } { "_id" : ObjectId("536232e35a87a26d8f721fa1"), "ltime" : ISODate("2012-11-04T07:58:55Z") } { "_id" : ObjectId("536232e65a87a26d8f721fa2"), "ltime" : ISODate("2012-11-05T07:58:55Z") } { "_id" : ObjectId("536232e85a87a26d8f721fa3"), "ltime" : ISODate("2012-11-06T07:58:55Z") } { "_id" : ObjectId("5362333b5a87a26d8f721fa4"), "ltime" : ISODate("2012-11-07T07:58:55Z") } { "_id" : ObjectId("536233445a87a26d8f721fa5"), "ltime" : ISODate("2012-11-08T07:58:55Z") } { "_id" : ObjectId("536233485a87a26d8f721fa6"), "ltime" : ISODate("2012-11-11T07:58:55Z") } { "_id" : ObjectId("536233fd5a87a26d8f721fa7"), "ltime" : ISODate("2012-11-12T00:00:00Z") } { "_id" : ObjectId("536234255a87a26d8f721fa8"), "ltime" : ISODate("2012-11-14T00:00:00Z") } { "_id" : ObjectId("536234385a87a26d8f721fa9"), "ltime" : ISODate("2012-11-14T11:11:11Z") } { "_id" : ObjectId("536234585a87a26d8f721faa"), "ltime" : ISODate("2014-05-01T11:47:36.144Z") } { "_id" : ObjectId("536235365a87a26d8f721fab"), "ltime" : ISODate("2014-05-01T11:51:18.926Z") } { "_id" : ObjectId("5362368c5a87a26d8f721faf"), "ltime" : ISODate("2014-05-01T19:56:11Z") } > > db.xiaorui.test.find({'ltime':{$gt:new Date("2014-1-3")}}) { "_id" : ObjectId("536234585a87a26d8f721faa"), "ltime" : ISODate("2014-05-01T11:47:36.144Z") } { "_id" : ObjectId("536235365a87a26d8f721fab"), "ltime" : ISODate("2014-05-01T11:51:18.926Z") }<span style="line-height:1.5;">{ "_id" : ObjectId("5362368c5a87a26d8f721faf"), "ltime" : ISODate("2014-05-01T19:56:11Z") }</span> |
python使用pymongo操作时间
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
str='2014-05-01 21:36' date_time = datetime.strptime(str,'%Y-%m-%d %H:%M') In [216]: for i in db.test.find({'ltime':{'$gt':date_time}}): .....: print i .....: .....: {u'ltime': datetime.datetime(2014, 5, 1, 21, 36, 31, 734000), u'_id': ObjectId('53624ddf2466d10c92f5e59e')} {u'ltime': datetime.datetime(2014, 5, 1, 21, 37, 44, 334000), u'_id': ObjectId('53624e282466d10c92f5e59f')} {u'ltime': datetime.datetime(2014, 5, 1, 21, 38, 55, 651000), u'_id': ObjectId('53624e6f2466d10c92f5e5a0')} {u'ltime': datetime.datetime(2014, 5, 1, 21, 43, 13, 707000), u'_id': ObjectId('53624f712466d10c92f5e5a1')} {u'ltime': datetime.datetime(2014, 5, 1, 21, 43, 30, 201000), u'_id': ObjectId('53624f822466d10c92f5e5a2')} {u'ltime': datetime.datetime(2014, 5, 1, 21, 43, 45, 815000), u'_id': ObjectId('53624f912466d10c92f5e5a3')} {u'ltime': datetime.datetime(2014, 5, 1, 21, 59, 28, 389000), u'_id': ObjectId('536253402466d10c92f5e5a4')} |
