/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

1 vote344 views1 answer
What is a Database?
SQL
1 vote338 views1 answer
Where database run
SQL
0 vote267 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote299 views4 answers
Fatal database postgres does not exist
SQL
0 vote319 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes368 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
3 votes322 views2 answers
Truncate all tables
SQL
2 votes326 views1 answer
Oracle calculated column
SQL
3 votes336 views3 answers
Order by postgres
SQL
0 vote333 views1 answer
Sql server roles and users
SQL