Posted on 10th September 2024|162 views
How to extract Epoch in PostgreSQL?
Posted on 10th September 2024| 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.