/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 vote196 views2 answers
Sql update top 100
SQL
8 votes191 views4 answers
Mysql update one table from another table multiple columns
SQL
4 votes187 views4 answers
What is primary key
SQL
0 vote207 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote207 views1 answer
Mysql return column names when table is empty
SQL
0 vote193 views1 answer
Mysql query to add hours to column in table
SQL
16 votes192 views1 answer
Mysql reset auto increment value
SQL
0 vote200 views1 answer
Sql select all tables from database change url
SQL
11 votes199 views6 answers
Distinct sql
SQL
0 vote201 views1 answer
Oracle session statistics
SQL