Re: Converting interval to numeric? - Mailing list pgsql-novice

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).