PostgreSQL - How to calculate difference between two timestamps?

You have two timestamp values: timestamp1 and timestamp2 and want to find the difference between the two.

If you want the results in hours, months, days, hours, etc:

SELECT age(timestamp1, timestamp2);

If you want the results in seconds only:

SELECT EXTRACT(EPOCH FROM timestamp 'timestamp1') -
       EXTRACT(EPOCH FROM timestamp 'timestamp2');

Or casting it this way:

SELECT
    EXTRACT(EPOCH FROM ('timestamp1'::timestamp - 'timestamp2'::timestamp));

Example:

SELECT
    EXTRACT(EPOCH FROM ('2018-06-28 12:01:38'::timestamp - '2017-12-11 11:30'::timestamp));

---

Need a good GUI Tool for PostgreSQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.


Download TablePlus free.