Mongodb Functions

objectid

Extracts the TIMESTAMP WITH TIME ZONE from a given ObjectId.

Supported Signatures

function objectid() returns objectid
function objectid(varchar) returns objectid

🔗 Official Documentation

objectid_timestamp

Extracts the TIMESTAMP WITH TIME ZONE from a given ObjectId.

Supported Signatures

function objectid_timestamp(objectid) returns timestamp

🔗 Official Documentation

timestamp_objectid

Creates an ObjectId from a TIMESTAMP WITH TIME ZONE.

Supported Signatures

function timestamp_objectid(timestamp(0)) returns objectid

🔗 Official Documentation