I have a table in PostgreSQL 8.3
with 2 timestamp
columns. I would like to get the difference between these timestamps
in seconds. Could you please help me how to get this done?
TableA
(
timestamp_A timestamp,
timestamp_B timestamp
)
I need to get something like (timestamo_B - timestamp_A)
in seconds (not just the difference between seconds, it should include hours, minutes etc).
This question is related to
postgresql
select age(timestamp_A, timestamp_B)
Answering to Igor's comment:
select age('2013-02-28 11:01:28'::timestamp, '2011-12-31 11:00'::timestamp);
age
-------------------------------
1 year 1 mon 28 days 00:01:28
SELECT (cast(timestamp_1 as bigint) - cast(timestamp_2 as bigint)) FROM table;
In case if someone is having an issue using extract.
Source: Stackoverflow.com