On Fri, Feb 11, 2005 at 01:48:06 +0000,
Sal Dkj <saldkj(at)hotmail(dot)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).