How do I convert a String like "11/21/2012" to Date in MongoDB?
I tried the following
obj.as_from = ISODate("11/21/2012");
and got this error
uncaught exception: invalid ISO date
Is there a simple way to convert the string above?
Asked
Active
Viewed 4,985 times
2
Julian
- 1,853
- 5
- 27
- 48
-
1Are you just using the mongo shell? If so, you can use the regular Date() constructor and it will return an ISODate – user602525 Dec 26 '13 at 03:26
-
When I use Date("11/21/2012") I get the current date... – Julian Dec 26 '13 at 03:31
-
Use the `new` operator. See my answer. – Rafa Viotti Dec 26 '13 at 03:32
-
Possible duplicate of [Converting string to date in mongodb](http://stackoverflow.com/questions/10942931/converting-string-to-date-in-mongodb) – Musa Haidari Oct 31 '15 at 09:39
2 Answers
4
As pointed by user602525, in the Mongo shell.
obj.as_from = new Date("11/21/2012");
Do not forget to use the new operator.
Rafa Viotti
- 9,998
- 4
- 42
- 62
-
Ok this works, any idea how to handle a string like "11/2012"? One that only shows the month and year. When I try that it defaults to 1970. – Julian Dec 26 '13 at 03:43
-
1In this case I would parse the date string manually and use the Date constructor: `new Date(2012, 10)`. Months start from zero in JavaScript. – Rafa Viotti Dec 26 '13 at 03:51
-
Thanks again. I notice the day deaults to "01". Is there a way to get it to default to "00" to represent nothing? – Julian Dec 26 '13 at 04:45
-
1A date represents some given fixed point in time. Without a day number it just wouldn't be a date and you'd better stick with a string. – Calimero Dec 26 '13 at 08:04
-
@Calimero that's what I was thinking. I actually have two dates in the document. One with a short month/year format and one that is more detailed. I just convert the detailed one and the the short format as a string. – Julian Dec 26 '13 at 16:22
