Details
-
Improvement
-
Status: Closed
-
Major - P3
-
Resolution: Done
-
None
-
Fully Compatible
Description
Since ObjectId() encompasses an approximation of insertion date it would be helpful if _id/things of ObjectId() type could be operated/projected the same way as Datetime type object.
{case}{$project:{$year:"$_id"}} would extract year out of ObjectId().getTimestamp equivalent.{case}
One question would be whether ObjectId could be operated on directly via date/interval arithmetic. I.e. whether it can be used anywhere a date can be used returning a standard Datetime type as a result from say {$subtract:["$_id",86400000]} which can only return ts of one day before that ObjectId's timestamp.
Attachments
Issue Links
- is documented by
-
DOCS-10404 Docs for SERVER-9406: Allow treating ObjectId type as date in $project phase
-
- Closed
-
- is related to
-
SERVER-24947 Need a type conversion mechanism for booleans, ISODates, ObjectID
-
- Closed
-
- links to