/SQL/Postgresql get difference in hours between two dates

Postgresql get difference in hours between two dates

select EXTRACT(
	EPOCH FROM now() - (now() - INTERVAL '5 HOUR')
)/3600

-- it will return 5

Source: stackoverflow.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

9 votes213 views3 answers
Sql delete where in
SQL
0 vote192 views1 answer
Mysql money value
SQL
0 vote193 views1 answer
Sql composite key
SQL
7 votes203 views2 answers
Mysql get year from date
SQL
0 vote215 views1 answer
Mysql custom sort order
SQL
25 votes203 views6 answers
Modify column name in mysql
SQL
0 vote209 views1 answer
How to remove default in mysql
SQL
0 vote245 views1 answer
How to drop a trigger in postgresql
SQL
0 vote261 views1 answer
Oracle swap partition
SQL
2 votes199 views1 answer
Mysql virtual column
SQL