河南省豫建設(shè)計(jì)院網(wǎng)站軟文廣告投放平臺(tái)
????????MongoDB 集合 test1,有字段 _id，createTime，createTimeStr，name字段 ， 查詢createTime不為空的，根據(jù) _id 生成該條記錄的創(chuàng)建時(shí)間時(shí)間戳并填寫到字段 createTime 字段中 ，并打印時(shí)間戳
// 查詢 createTime 為空的記錄
var cursor = db.getCollection("test1").find({"createTime" : null});while (cursor.hasNext()) {var doc = cursor.next();try {// 提取時(shí)間戳部分var timestamp = doc._id.getTimestamp();var timestamp2 = Date.parse(timestamp);// 格式化時(shí)間字符串為“yyyyMMdd”var formattedDate = timestamp.toISOString().slice(0, 10).replace(/-/g, '');print("Document _id: " + doc._id +" , timestamp2 " + timestamp2 + " , Create Time: " + formattedDate);db.test1.update({ _id: doc._id },{ $set: { createTime: timestamp2, createTimeStr: formattedDate } });} catch (e) {// 打印異常信息print("Error processing document _id: " + doc._id + ". Error: " + e);// 繼續(xù)執(zhí)行下一個(gè)文檔continue;}
}