oid_to_timestamp {mongolite}

Get OID date

Description

The initial 4 bytes of a MongoDB OID contain a timestamp value, representing the ObjectId creation, measured in seconds since the Unix epoch.

Usage

oid_to_timestamp(oid)

Arguments

oid

string or raw value with document oid

Examples

oid_to_timestamp('5349b4ddd2781d08c09890f3')