Re: Converting interval to numeric?

Bruno, thanks.

>From: Bruno Wolff III <bruno@wolff.to>
>To: Sal Dkj <saldkj@hotmail.com>
>CC: pgsql-novice@postgresql.org
>Subject: Re: Converting interval to numeric?
>Date: Thu, 10 Feb 2005 22:58:25 -0600
>
>On Fri, Feb 11, 2005 at 01:48:06 +0000,
>   Sal Dkj <saldkj@hotmail.com> wrote:
> > 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?
>
>EXTRACT the EPOCH from the difference of the timestamps. This will give
>you the elapsed times in seconds (as a float8 I think).

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