var mongoClient = require('mongodb').MongoClient;
var url = "mongodb://r97:pulsa123@172.23.3.61:27017/cjk?authMechanism=SCRAM-SHA-1&authSource=cjk";

mongoClient.connect(url, function(err, db) {
    if (err) {
        console.log('gagal konek ke db');
        return;
    }
    var i = 0;
    db.collection('trx').find({}).each(function (err, doc) {
        if (err) {
            console.log('gagal find each');
            return;
        }
        
        try {
            var ts = doc.ts;
            var ts_date = ts.substring(0, 10);
            console.log(++i + '. ' + ts + ' => ' + ts_date);
            
            db.collection('trx').update({_id: doc._id}, {ts_date: ts_date});
        }
        catch(except) {
        }
        
        
    });
});