rodrigoborgesdeoliveira/setFieldToIdTimestamp.js

Created June 6, 2022 13:45

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rodrigoborgesdeoliveira/da696e364a54fb6d3588c8e317f1970c.js"></script>
Save rodrigoborgesdeoliveira/da696e364a54fb6d3588c8e317f1970c to your computer and use it in GitHub Desktop.

Download ZIP

On MongoDB, update createdAt (or any other field) based on _id's timestamp

Raw

setFieldToIdTimestamp.js

db.collection.updateMany({}, [{ $set: { createdAt: { $toDate: "$_id" } } }])

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment