Pulling created date from the Objectid

[sachmans]

HI,

I am trying to work out how to use a function like this getTimestamp() in the YAML or another way to get the date/time from the ObjectID for the particular document to know when it was created.

Any help on this would be greatly useful.

Sachin

[BradRuderman]

@sachmans I know this probably isn't ideal but you can pull it out with a query, perhaps even creating a function:

SELECT to_timestamp(('x' || lpad(substring(object_id,0,9), 8, '0'))::bit(32)::int)::timestamp ts
FROM objects