/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 vote147 views1 answer
Show structure of table in sql
SQL
0 vote147 views1 answer
Datagrip execute procedure
SQL
0 vote134 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote133 views1 answer
Oracle index hint
SQL
0 vote106 views1 answer
Postgres create database if not exists
SQL
2 votes135 views1 answer
Set column to not null mysql
SQL
1 vote137 views1 answer
Pl sql ptint
SQL
7 votes140 views3 answers
Select latest entry in sql table
SQL
0 vote167 views1 answer
Day of the week sqlite
SQL
6 votes152 views2 answers
Return columns from table sql
SQL