/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 vote254 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote258 views1 answer
Mysql cdn link
SQL
0 vote251 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote283 views3 answers
Rows, INSERT INTO
SQL
0 vote287 views1 answer
Alter table add check constraint oracle
SQL
1 vote273 views2 answers
Postgresql remote connect
SQL
3 votes285 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
5 votes247 views2 answers
Update all rows mysql
SQL
31 votes280 views4 answers
Mysql grant execute
SQL
0 vote276 views1 answer
Find duplicate users by email address in mysql
SQL