In my mongo database I have field timestamp which holds time of creation in timestamp ie: "timestamp": 1544029233021
I want to create TTL index on this field, but in docs example is done on "createdAt": new Date(),
which is ISODate("2018-12-13T17:00:10.433Z")
Is it possible to in any way to make TTL Index work on timestamp field?
Because this doesnt work:
db.coll.createIndex( { "timestamp": 1 }, { expireAfterSeconds: 3600 } )
The documents aren't being expired because the
timestamp
value is an integer.TTL indexes will only work on documents where the indexed field is a Date or holds an array of Dates:
(https://docs.mongodb.com/manual/core/index-ttl/#expiration-of-data)