/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

0 vote347 views3 answers
Get free card roblox
SQL
-1 vote363 views1 answer
Can pandas fetch data from sql
SQL
3 votes359 views1 answer
Postgresql db owner change
SQL
0 vote360 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote337 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote399 views1 answer
Mysql relationships between tables
SQL
1 vote412 views1 answer
Sql first day quarter
SQL
0 vote342 views1 answer
Select password from user mysql
SQL
0 vote360 views1 answer
Ver usuarios mysql
SQL
1 vote308 views1 answer
Mssql string length
SQL