blocks|key|3951516|text|mongodb中没有time类型，只有datetime类型。如果您真的只使用时间，而根本不关心日期组件，我建议将日期组件设置为1-jan-1+(year+1)作为标记。在您的示例中，521177看起来是以微秒为单位的，而不是毫秒，因此它将直接进入python+datetime对象：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3951517|#++Get+your+time+object+from+MySQL+and+extract+hour,+mins,+secs,+and+microseconds.
#++Then,+construct+a+full+datetime+with+the+marker+date:
d7+=+datetime.datetime(1,+1,+1,+18,+59,+32,+521177)
db.foo.insert({"myDate":+d7});

db.foo.find();
{+"_id"+:+ObjectId("5ce45553283c3282ad1cec34"),+"myDate"+:+ISODate("0001-01-01T18:59:32.521Z")+}|code-block|syntax|javascript|3951518|请注意，MongoDB+datetime的时间分量仅对millis准确。如果您需要捕获micros，则必须将其存储在对等字段中，例如|3951519|micros+=+521177
d7+=+datetime.datetime(1,+1,+1,+18,+59,+32,+micros)
db.foo.insert({"myDate":+d7,+"micros":+micros});|3951520|或者利用丰富的类型，创建一个小的date%2Bmicros结构：|3951521|micros+=+521177
d7+=+datetime.datetime(1,+1,+1,+18,+59,+32,+micros)
db.foo.insert({"myDate":+{"d":d7,+"micros":+micros}});|3951522|这样，您就可以轻松地携带这两部分数据：|3951523|db.foo.findOne({},+{"myDate":1}+);
{
++++"_id"+:+ObjectId("5ce457df283c3282c43a79b7"),
++++"myDate"+:+{
++++++++"micros"+:+521177,
++++++++"d"+:+ISODate("0001-01-01T18:59:32.521Z")
++++}
}|3951524|在任何情况下，您都可以直接在从MongoDB获取的date对象上使用python+datetime的timedelta特性。使用1-Jan-1约定，日期差异将始终为零，从而产生时间差异--尽管只对millis准确：|3951525|micros+=+521177
d7+=+datetime.datetime(1,+1,+1,+18,+59,+32,+micros)
db.foo.insert({"_id":0,+"myDate":+{"d":d7,+"micros":+micros}});
micros+%2B=+3780++++#+jump+ahead+in+time+a+bit....
d7+=+datetime.datetime(1,+1,+1,+18,+59,+32,+micros)
db.foo.insert({"_id":1,+"myDate":+{"d":d7,+"micros":+micros}});

doc1+=+db.foo.find_one({"_id":0});
doc2+=+db.foo.find_one({"_id":1});

delta+=+doc2['myDate']['d']+-+doc1['myDate']['d']
print+"delta:+",+delta

delta:++0:00:00.003000|3951526|当然，你可以通过添加micros模1000来获得完全保真度，以获得不属于millis的micros，这些micros已经与日期一起存储：|3951527|adj1+=+doc1['myDate']['d']+%2B+datetime.timedelta(microseconds=doc1['myDate']['micros']+%25+1000)
adj2+=+doc2['myDate']['d']+%2B+datetime.timedelta(microseconds=doc2['myDate']['micros']+%25+1000)

delta+=+adj2+-+adj1
print+"delta:+",+delta

delta:++0:00:00.003780|3951528|当然，如果您决定使用迷你结构来携带datetime%2Bmicros，那么将调用一个函数：|3951529|def+mdb2py(minidatestruct):
++++return+minidatestruct['d']+%2B+datetime.timedelta(microseconds=minidatestruct['micros']+%25+1000)

adj1+=+mdb2py(doc1['myDate'])
adj2+=+mdb2py(doc2['myDate'])

delta+=+adj2+-+adj1
print+"delta:+",+delta

delta:++0:00:00.003780|3951530|entityMap^0|2J|6|3M|8|0|0|C|8|0|0|0|0|0|0|15|8|1E|9|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|1F|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1J|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1K|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1L|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1M|8|@]|D|@]|E|$]]|$1|U|3|V|5|H|7|1N|8|@]|D|@]|E|$I|J]]|$1|W|3|X|5|6|7|1O|8|@$9|1P|A|1Q|B|C]|$9|1R|A|1S|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|H|7|1T|8|@]|D|@]|E|$I|J]]|$1|10|3|11|5|6|7|1U|8|@]|D|@]|E|$]]|$1|12|3|13|5|H|7|1V|8|@]|D|@]|E|$I|J]]|$1|14|3|15|5|6|7|1W|8|@]|D|@]|E|$]]|$1|16|3|17|5|H|7|1X|8|@]|D|@]|E|$I|J]]|$1|18|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]]|19|$]]

There is no time type in mongodb, only datetime. If you truly only ever use the time and do not care about the date component at all, I recommend setting the date component to 1-jan-1 (year 1) as a marker. In your example, <code>521177</code> looks like it is in microseconds, not milliseconds, so that will go into a python <code>datetime</code> object straight away:

<pre><code># Get your time object from MySQL and extract hour, mins, secs, and microseconds.
# Then, construct a full datetime with the marker date:
d7 = datetime.datetime(1, 1, 1, 18, 59, 32, 521177)
db.foo.insert({"myDate": d7});

db.foo.find();
{ "_id" : ObjectId("5ce45553283c3282ad1cec34"), "myDate" : ISODate("0001-01-01T18:59:32.521Z") }
</code></pre>

Note that the time component of the MongoDB <code>datetime</code> is accurate only to millis. If you require capture of micros, you will have to store that in a peer field, e.g.

<pre><code>micros = 521177
d7 = datetime.datetime(1, 1, 1, 18, 59, 32, micros)
db.foo.insert({"myDate": d7, "micros": micros});
</code></pre>

Or take advantage of rich types and make a little date+micros structure:

<pre><code>micros = 521177
d7 = datetime.datetime(1, 1, 1, 18, 59, 32, micros)
db.foo.insert({"myDate": {"d":d7, "micros": micros}});
</code></pre>

This way, you can easily carry around both pieces of data:

<pre><code>db.foo.findOne({}, {"myDate":1} );
{
 "_id" : ObjectId("5ce457df283c3282c43a79b7"),
 "myDate" : {
 "micros" : 521177,
 "d" : ISODate("0001-01-01T18:59:32.521Z")
 }
}
</code></pre>

In any event, you can use the <code>timedelta</code> features of python <code>datetime</code> directly on the date objects fetched from MongoDB. With the 1-Jan-1 convention, the date diff will always be zero, yielding you a diff in time -- albeit accurate only to millis:

<pre><code>micros = 521177
d7 = datetime.datetime(1, 1, 1, 18, 59, 32, micros)
db.foo.insert({"_id":0, "myDate": {"d":d7, "micros": micros}});
micros += 3780 # jump ahead in time a bit....
d7 = datetime.datetime(1, 1, 1, 18, 59, 32, micros)
db.foo.insert({"_id":1, "myDate": {"d":d7, "micros": micros}});

doc1 = db.foo.find_one({"_id":0});
doc2 = db.foo.find_one({"_id":1});

delta = doc2['myDate']['d'] - doc1['myDate']['d']
print "delta: ", delta

delta: 0:00:00.003000
</code></pre>

You can of course get full fidelity back by adding in the micros modulo 1000 to get the micros that are not part of the millis already stored with the date:

<pre><code>adj1 = doc1['myDate']['d'] + datetime.timedelta(microseconds=doc1['myDate']['micros'] % 1000)
adj2 = doc2['myDate']['d'] + datetime.timedelta(microseconds=doc2['myDate']['micros'] % 1000)

delta = adj2 - adj1
print "delta: ", delta

delta: 0:00:00.003780
</code></pre>

And of course if you settle on using the mini struct to carry datetime+micros, then a function is called for:

<pre><code>def mdb2py(minidatestruct):
 return minidatestruct['d'] + datetime.timedelta(microseconds=minidatestruct['micros'] % 1000)

adj1 = mdb2py(doc1['myDate'])
adj2 = mdb2py(doc2['myDate'])

delta = adj2 - adj1
print "delta: ", delta

delta: 0:00:00.003780
</code></pre>

I am writing a program to transfer data from MySQL to MongoDB in python. However, I have trouble transferring time data type to MongoDB:
- MySQL side has a time data field in the example format: '18: 59: 32.521177 '("hours: minute: second: milisecond")
I want to ask in MongoDB what is the corresponding data type of the above field? How can I use python to convert it?

Data type of time in MongoDB?

我正在写一个程序，用Python语言将数据从MySQL传输到MongoDB。但是，我无法将时间数据类型转换为MongoDB：- MySQL端有一个示例格式的时间数据字段：'18: 59: 32.521177‘(“小时:分钟:秒:毫秒”)我想问一下MongoDB中上述字段对应的数据类型是什么？如何使用python进行转换...

问MongoDB中时间的数据类型是什么？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB中时间的数据类型是什么？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB中时间的数据类型是什么？
EN