Converting interval to numeric? - Mailing list pgsql-novice

From Sal Dkj
Subject Converting interval to numeric?
Date
Msg-id BAY18-F17426A75BEB12964D02490D4770@phx.gbl
Whole thread Raw
Responses Re: Converting interval to numeric?
List pgsql-novice
Hello, I'm trying to calculate the difference between two timestamps and
have the return value in minutes.

So, for instance:
Time 1 = 1/1/2005 12:00
Time 2 = 1/2/2005 12:00

If you subtract Time 1 from Time 2, it returns an interval value of '1 day'.
  Extracting hours or minutes from this obviously gives 0.  What's the trick
here?

Thanks!

_________________________________________________________________
Don�t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


pgsql-novice by date:

Previous
From:
Date:
Subject: Re: how to know this row has been referenced or not????
Next
From: "Mike G."
Date:
Subject: Re: PL/pgSQL: FOT Loops vs Cursors