时间:2021-07-01 10:21:17 帮助过:3人阅读
给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