MongoDB - Update only time to datetime

Asked Feb 21 '18 at 06:54

Active Feb 21 '18 at 06:54

Viewed 312 times

I'm trying to find a way to update only the "time" part. (only with mongodb)

For example, I have the following datetimes

2018-01-03 01:00:00.000
2018-01-04 02:00:00.000
2018-01-05 03:00:00.000

And I want to update only the time. The desired result is

2018-01-03 10:00:00.000
2018-01-04 10:00:00.000
2018-01-05 10:00:00.000

asked Feb 21 '18 at 06:54

Michalis

is this question ? what is your data , time come from where? – Nozar Safari Feb 21 '18 at 07:01
Will the query be used in the mongo shell, or a driver? In the last case which one? – Xavier Guihot Feb 21 '18 at 07:04
I'm using mongo with nodejs – Michalis Feb 21 '18 at 07:05
https://stackoverflow.com/questions/31760736/how-to-update-collection-and-increment-hours-for-iso-date – dnickless Feb 21 '18 at 07:06
You will need to load and update each document. The above link points to a good example showing the basic approach. – dnickless Feb 21 '18 at 07:07
This link might help as well: https://stackoverflow.com/a/31262746/9297144 – Xavier Guihot Feb 21 '18 at 07:08

0 Answers0