/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 vote244 views1 answer
Find how many tables in database sql query
SQL
0 vote179 views1 answer
How to get last client id sql
SQL
1 vote239 views1 answer
Snowflake rename column name
SQL
0 vote247 views1 answer
Delete duplicate rows
SQL
0 vote225 views1 answer
Unique index in mysql
SQL
0 vote230 views1 answer
Mysql pad zeros
SQL
2 votes180 views1 answer
Sql group by different columns
SQL
0 vote191 views0 answer
SQL
0 vote237 views1 answer
Mysql limit order by
SQL
10 votes243 views2 answers
SQL rounding numbers
SQL