Converting interval to numeric?

From: "Sal Dkj" <saldkj(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Converting interval to numeric?
Date: 2005-02-11 01:48:06
Message-ID: BAY18-F17426A75BEB12964D02490D4770@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike G. 2005-02-11 04:39:21 Re: PL/pgSQL: FOT Loops vs Cursors
Previous Message operationsengineer1 2005-02-10 20:21:33 Re: how to know this row has been referenced or not????