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

1 vote366 views1 answer
Select dba users oracle
SQL
0 vote395 views1 answer
Mysql value ends with
SQL
1 vote378 views1 answer
Mysql strict_trans_tables
SQL
1 vote375 views3 answers
Connection string mysql
SQL
0 vote366 views1 answer
Find how many tables in database sql query
SQL
0 vote426 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote369 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote346 views1 answer
Set mysql mode global query
SQL
13 votes363 views6 answers
Mysql update from select
SQL
3 votes387 views2 answers
Search text in all sql server stored procedure
SQL