Sign in Get Started

DATEDIFF minute postgres

Lionel Aguero 
  -- 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
View another examples Add Own solution
Log in, to leave a comment

0
0
Phoenix Logan 186120 points 

                                       CREATE OR REPLACE FUNCTION DateDiff (units VARCHAR(30), start_t TIME, end_t TIME) 
     RETURNS INT AS $$
   DECLARE
     diff_interval INTERVAL; 
     diff INT = 0;
   BEGIN
     -- Minus operator for TIME returns interval 'HH:MI:SS'  
     diff_interval = end_t - start_t;
 
     diff = DATE_PART('hour', diff_interval);
 
     IF units IN ('hh', 'hour') THEN
       RETURN diff;
     END IF;
 
     diff = diff * 60 + DATE_PART('minute', diff_interval);
 
     IF units IN ('mi', 'n', 'minute') THEN
        RETURN diff;
     END IF;
 
     diff = diff * 60 + DATE_PART('second', diff_interval);
 
     RETURN diff;
   END;
   $$ LANGUAGE plpgsql;

0
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
postgresql difference between two dates in minutes postgresql timestamp difference in seconds datediff in seconds postgresql postgresql time difference postgresql timestamp difference in minutes datediff on postgres difference between timestamp postgresql as hour postgresql time diff between timestamp time diff in postgres calculate time difference postgresql postgresql difference between two timestamps in minutes getting the time difference between two dates psql postgresql difference between two dates in hours postgresql get hour difference between two dates postgress datediff in hours postgres difference between time and timestamp postgresql date difference between two timestamps DATEDIFF in psql find difference between two timestamps in hours postgresql difference between timestamps postgresql postgres diff between two timestamps minutes how to calculate time difference in hours postgresql postgres timestamp differences in seconds postgres date difference in years time difference in hours in postgre sql postgres time difference between two timestamps postgres datediff in seconds postgresql timestamp difference postgresql time difference in seconds timestamp difference in minutes postgresql PostgreSQL difference between two timestamps postgresql difference in hours between two dates hours difference between two dates in psql postgres date difference in minutes postgresql get difference in hours between two dates timestamp difference in postgresql datediff postgresql minutes postgresql time difference in minues postgres time difference in minutes postgres difference between two dates in days subtract dates postgresql how to check timestamp difference in postgre datediff postgressql postgres days between dates pgsql date diff postgres date difference seconds postgresql calculate days between dates date difference postgresql get date difference postgresql postgres get days between two dates datediff in postgresql have difference 10 months between start and end date how to get those months in postgresql postgresql calculate days between two timestamps postgres duration between timestamps sql get length from 2 date postgresql COMPARE DAYS PSQL postgres number of days between two timestamps difference between timestamps postgres in minutes postgres difference between two timestamps two datetime diff in second postgresql postgresql time difference in hours calculate time between following date postgresql postgresql interval between two timestamps datediff postgres today get difference between two timestamps in days postgresql how to subtract two timestamp from each other in postgres how to get differene in days in postgresql postgresql calculate field date difference postgresql subtract dates postgres date difference in days postgresql calculate time difference time difference between two dates in postgresql postgres time in minutes between two dates subtract timestamps postgresql get number of days between two dates postgresql psql get difference of time in seconds postgres difference between 2 dates diff in postgresql postgresql substract dates calulate between date progres sql postgresql get hours between two dates from month postgresql get days between two dates from month postgresql get days between two dates postgres number of seconds between two dates postgresql datdiff postgresql difference between two dates in seconds pg difference in seconds difference between dates postgresql postgresql date_diff postgres difference date how to find difference between two dates in postgresql how to find difference between two timestamps in postgresql postgresql find difference between two dates how to compare date in secound postgresql difference between two dates postgresql minus date in postgresql get difference between two dates postgresql postgres date diff in days postgresql datediff days postgres datdiff datediff postgres number of days between two dates in postgresql postgres diff between dates postgresql calculate difference between two dates postgresql timestamp diff now in days subtract two dates postgres postgres get number of days between two dates postgres get date difference in days postgres date difference in seconds from now postgres date difference in seconds diff of two datetime in minute postgresql date difference in sql postgres postgresql number of days between two dates postgres difference between two dates date diff to integer postgresql datediff postgresql example time difference between date and now psql time between dates psql psql seconds between select datediff postgresql postgresql datetime difference into minute datetime subtraction postgresql datediff psql psql datediff PostgreSQL datediff in seconds PostgreSQL calculate timestampdiff duration calculation in postgresql postgres timestamp difference in days postgres timestamp difference postgres date difference in hours how to check time difference between two timestamp in postgresql postgresql minutes between timestamps postgres datediff in hours postgres timestamp difference more than 1 second date difference in postgresql postgres date difference 1 second postgresql timestamp diff minutes seconds postgresql difference between two dates in minutes and seconds postgresql difference between two dates in days postgres datediff weeks postgres get time postgresql query to find time difference date difference in days postgresql difference in days between two dates postgresql timediff postgresql diff days select postgres timestamp diff postgresql postgresql difference between timestamps datediff postgresql postgresql get difference between two dates date minus date postgres postgres date difference postgresql datediff postgres datediff Postgres date diff postgresql date difference DATEDIFF minute postgres
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source