mongodb插入时间

给mongodb插入日期格式的数据时发现，日期时间相差8个小时，原来存储在mongodb中的时间是标准时间UTC +0:00，而中国的时区是+8.00 。

取出时正确

db.test.find()[0].time.getHours()

因此在插入的时候需要对时间进行处理：

db.test.insert({"Time":<span style="color: #0000ff">new</span> Date(<span style="color: #0000ff">new</span> Date().getFullYear()+"-"+(<span style="color: #0000ff">new</span> Date().getMonth()+1)+"-"+<span style="color: #0000ff">new</span> Date().getDate()+ " "+<span style="color: #0000ff">new</span><span style="color: #000000"> Date().toLocaleTimeString())})
db.test.insert({</span>‘time‘:ISODate("2012-11-02 07:58:51"<span style="color: #000000">)})
db.user.uinfo.insert({</span>‘ltime‘:ISODate("2012-11-02 07:58:51")})

用自定义函数:

<span style="color: #0000ff">function</span><span style="color: #000000"> insertDate(time){
    time.setHours(time.getHours()</span>-8<span style="color: #000000">);
    </span><span style="color: #0000ff">return</span><span style="color: #000000"> time;
}
insertDate(</span><span style="color: #0000ff">new</span> Date(2017,9,9,9,63,72<span style="color: #000000">))
</span><span style="color: #0000ff">function</span><span style="color: #000000"> getFormatDate(time){
    year </span>=<span style="color: #000000"> time.getFullYear();
    mon </span>= time.getMonth()+1<span style="color: #000000">;
    date </span>=<span style="color: #000000"> time.getDate();
    hour </span>=<span style="color: #000000"> time.getHours();
    min </span>=<span style="color: #000000"> time.getMinutes();
    sec </span>=<span style="color: #000000"> time.getSeconds();
    newtime </span>= year+‘-‘+mon+‘-‘+date+‘ ‘+hour+‘:‘+min+‘:‘+<span style="color: #000000">sec;
    </span><span style="color: #0000ff">return</span><span style="color: #000000"> newtime;
}</span>

mongodb插入时间

标签：存储   ring   nbsp   日期   let   find   info   cond   oda