Postgres date difference seconds

-- difference in seconds between two dates

select extract(epoch from ('2020-03-30 09:55:56'::timestamp - '2020-03-30 08:54:55'::timestamp));
-- result : 3661

DATEDIFF minute postgres

  -- Difference between Dec 30, 2011 08:54:55 and  Dec 30, 2011 08:56:10 in minutes
  SELECT (DATE_PART('day', '2011-12-30 08:56:10'::timestamp - '2011-12-30 08:54:55'::timestamp) * 24 * 60 + 
               DATE_PART('hour', '2011-12-30 08:56:10'::timestamp - '2011-12-30 08:54:55'::timestamp)) * 60 +
               DATE_PART('minute', '2011-12-30 08:56:10'::timestamp - '2011-12-30 08:54:55'::timestamp);
  -- Result: 1
 
  -- Time only
  SELECT DATE_PART('hour', '08:56:10'::time - '08:54:55'::time) * 60 +
              DATE_PART('minute', '08:56:10'::time - '08:54:55'::time);
  -- Result: 1

Source: sqlines.com

Postgresql get difference between two dates

select age('2010-04-01', '2012-03-05'),
       date_part('year',age('2010-04-01', '2012-03-05')),
       date_part('month',age('2010-04-01', '2012-03-05')),
       date_part('day',age('2010-04-01', '2012-03-05'));

-1

Source: stackoverflow.com

Similar codes

0 vote296 views1 answer
Full outer join in mariadb mysql
SQL
1 vote279 views1 answer
Moodle query first user access
SQL
0 vote272 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote288 views2 answers
Uninstall postgresql mac
SQL
0 vote275 views1 answer
How get data from database if id not found then search another column
SQL
12 votes285 views2 answers
Update column data type postgres
SQL
18 votes275 views3 answers
Mysql number format
SQL
1 vote283 views1 answer
Simple project for database
SQL
0 vote257 views1 answer
Oracle index hint multiple tables example
SQL
1 vote307 views1 answer
Postgresql if 0 then 1
SQL