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

7 votes310 views2 answers
Create index mysql
SQL
0 vote320 views1 answer
Implicit inner join table alias with id values
SQL
0 vote351 views1 answer
Mysqli_connect using prepare statement
SQL
1 vote350 views1 answer
Random name function in mysql for nvarchar
SQL
59 votes564 views6 answers
Alter table sql
SQL
5 votes355 views2 answers
Create table mysql example auto_increment
SQL
6 votes340 views1 answer
T-sql test if table exists
SQL
0 vote366 views3 answers
How to assign custom id in mysql
SQL
0 vote341 views1 answer
Interview experience as a call?
SQL
0 vote361 views1 answer
C# mysql data reader from two tables
SQL