Horje
postgresql get difference in hours between two dates Code Example
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'));
Source: stackoverflow.com
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



Sql

Related
how to change a collumn name in sql Code Example how to change a collumn name in sql Code Example
print year of a date sql Code Example print year of a date sql Code Example
postgres week number Code Example postgres week number Code Example
name '_mysql' is not defined Code Example name '_mysql' is not defined Code Example
sqlite insert if not exists Code Example sqlite insert if not exists Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje