Posted on 26th April 2024
Extracting Epoch is a simple process for different versions of PostgreSQL by using this command:
SELECT extract(EPOCH FROM TIMESTAMP '1970-01-01'::Timestamp at time zone ‘GMT’);
As this will extract Epoch from Timestamp.
STILL GOT QUERIES?