-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: Aggregation Framework, Querying
-
Query Execution
-
Fully Compatible
-
(copied to CRM)
The $dateFromString Format Specifiers don't include the strftime %j modifier which is used to decode the day of the year as a decimal number (range 001 to 366).
It appears that this modifier is understood as part of kDateToStringFormatMap from timelib's TIMELIB_FORMAT_DAY_OF_YEAR when converting from a date to a string, but not from a string to a date.
For example:
db.foo.drop() db.foo.insert({ _id: 1, d: "2020-194-14:24:45.463" }); db.foo.aggregate( [ { $project: { date: { $dateFromString: { dateString: "%d", format: "%Y-%j-%H:%M:%S.%L" } } } } ] ) // "errmsg" : "Failed to optimize pipeline :: caused by :: Invalid format character '%j' in format string",
Note that for the above we were able to work around this limitation as follows:
db.foo.drop() db.foo.insert({ _id: 1, d: "2020-194-14:24:45.463" }); db.foo.aggregate([ { $project: { date: { $let: { vars: { parts: { $split: [ "$d", "-" ] } }, in: { $add: [ { $toDate: { $concat: [ { $arrayElemAt: [ "$$parts", 0 ] }, "-01-01T", { $arrayElemAt: [ "$$parts", 2 ] } ] } }, { $multiply: [ { $subtract: [ { $toInt: { $arrayElemAt: [ "$$parts", 1 ] } }, 1 ] }, 86400000 ] } ] } } } }} ]); // { "_id" : 1, "date" : ISODate("2020-07-12T14:24:45.463Z") }
- is depended on by
-
DRIVERS-2536 $dateFromString support for additional format specifiers (such as "%j" for day of year)
-
- Closed
-
- is related to
-
SERVER-74002 Day-of-year (%j) parsing inconsistency
-
- Closed
-
- split to
-
SERVER-73402 timelib support for additional format specifiers
-
- Closed
-