Python method to convert ObjectId of MongoDB as string to timestamp

Question

have got a JSON with user_uuid": "6027fd7ad748412d1c1e80e7", would like to convert it to a timestamp in millisecond.

Any help please?

Many Thanks,

It seems to have a 4-byte value representing the seconds since the Unix epoch, lexev.org/en/2015/timestamp-objectid-mongodb — Carlo Allocca
– Carlo Allocca, Commented Jun 10, 2021 at 20:15

ignoring_gravity · Accepted Answer · 2021-11-02 10:31:26Z

2

It seems to have a 4-byte value representing the seconds since the Unix epoch

Indeed, that's all you need to do:

>>> uuid = "6027fd7ad748412d1c1e80e7"
>>> seconds_since_unix_epoch = int(uuid[:8], base=16)
>>> seconds_since_unix_epoch
1613233530

Then, convert to datetime:

>>> import datetime as dt
>>> dt.timedelta(seconds=seconds_since_unix_epoch) + dt.date(1970, 1, 1)
datetime.date(2021, 2, 13)

answered Jul 6, 2021 at 7:13

ignoring_gravity

11.1k7 gold badges45 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1