/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

5 votes386 views4 answers
Mysql update column with value from another table
SQL
10 votes362 views4 answers
Drop primary key
SQL
0 vote337 views1 answer
List mysql tables and views
SQL
0 vote361 views1 answer
Mysql match in serialized data
SQL
0 vote331 views1 answer
Select password from user mysql
SQL
0 vote350 views1 answer
Sql get count without group by
SQL
1 vote375 views2 answers
Sql server backup table
SQL
0 vote344 views1 answer
Add multiple field in table sql
SQL
0 vote356 views1 answer
Call scalar valued function sql
SQL
10 votes319 views2 answers
Sql where clause multiple values
SQL