mongo convert field to NumberLong

Question

In mongo I want to convert for docs in a collection:

{   
 "timestamp" : 1494624438268.0
}

to

{    
"timestamp" : NumberLong(1494624438268)
}

How can I do that?

Don't know what exactly you are looking for ...Here's a link for ur help : https://docs.mongodb.com/manual/core/shell-types/#numberlong... — Nikhil, May 23 '17 at 17:16

score 2 · Accepted Answer · answered May 23 '17 at 17:35

2

i found it

db.getCollection('collection-name').find().limit(10).forEach(function(data) {
if (data.timestamp instanceof NumberLong === false) {
    data.timestamp=NumberLong(data.timestamp);});

answered May 23 '17 at 17:35

venkatesh p

33
6

score 0 · Answer 2 · answered May 23 '17 at 17:25

0

You need to select your document and then update with the corresponding type.

db.collection.updateOne( { timestamp: 1494624438268.0 }, { $set:  { timestamp: NumberLong("1494624438268") } } )

answered May 23 '17 at 17:25

Sercan Ozdemir

4,641
3
34
64

i want to iterate and do it for all records in the collection. – venkatesh p May 23 '17 at 17:34

mongo convert field to NumberLong

2 Answers2