DATEDIFF minute postgres

  -- Difference between Dec 30, 2011 08:54:55 and  Dec 30, 2011 08:56:10 in minutes
  SELECT (DATE_PART('day', '2011-12-30 08:56:10'::timestamp - '2011-12-30 08:54:55'::timestamp) * 24 * 60 + 
               DATE_PART('hour', '2011-12-30 08:56:10'::timestamp - '2011-12-30 08:54:55'::timestamp)) * 60 +
               DATE_PART('minute', '2011-12-30 08:56:10'::timestamp - '2011-12-30 08:54:55'::timestamp);
  -- Result: 1
 
  -- Time only
  SELECT DATE_PART('hour', '08:56:10'::time - '08:54:55'::time) * 60 +
              DATE_PART('minute', '08:56:10'::time - '08:54:55'::time);
  -- Result: 1

Source: sqlines.com

Similar codes

0 vote184 views1 answer
Mysql grant user wildcard database
SQL
15 votes150 views5 answers
If null mysql
SQL
0 vote162 views1 answer
Insert or update sql firebird
SQL
1 vote168 views3 answers
SELECT * FROM
SQL
1 vote146 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote168 views1 answer
Mysql curdate between two dates
SQL
0 vote153 views1 answer
Oracle array
SQL
11 votes154 views1 answer
How to get ddl for materialized view
SQL
18 votes151 views2 answers
Sql inner join
SQL
13 votes158 views4 answers
What is sql
SQL