Trino Functions
Mongodb Functions
objectid
Extracts the TIMESTAMP WITH TIME ZONE from a given ObjectId.
Supported Signatures
function objectid() returns objectid
function objectid(varchar) returns objectid
objectid_timestamp
Extracts the TIMESTAMP WITH TIME ZONE from a given ObjectId.
Supported Signatures
function objectid_timestamp(objectid) returns timestamp
timestamp_objectid
Creates an ObjectId from a TIMESTAMP WITH TIME ZONE.
Supported Signatures
function timestamp_objectid(timestamp(0)) returns objectid