Posted on 29th April 2025|162 views
How to extract Epoch in PostgreSQL?
Posted on 29th April 2025| views
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.