/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 vote337 views1 answer
Postgresql inheritance
SQL
0 vote310 views1 answer
Insensitive case match sqlalchemy
SQL
1 vote308 views3 answers
Sql server get week dates from week number
SQL
0 vote309 views1 answer
MySQL import data from large CSV file
SQL
0 vote278 views1 answer
Hallo
SQL
1 vote309 views1 answer
Mysql backup skip table
SQL
11 votes302 views4 answers
Query DISTINCT
SQL
17 votes316 views4 answers
Sort by mysql
SQL
11 votes337 views4 answers
Update row in mysql
SQL
0 vote291 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL