select extract(epoch from interval '2 hours')/60;
'epoch' returns the number epoch seconds that comprise the interval.
That differs from 'seconds' which just returns the "seconds place",
which is zero for 2:00:00 of course.
-Casey
On Oct 6, 2006, at 12:22 PM, Chris Hoover wrote:
> If I subtract 2 timestamps, how do I get the results returned as
> the total number of minutes.
>
> example
>
> now() - (now()-'2 hours'::interval) = 2:00:00 -- I need the result
> returned as 120 minutes.
>
> Thanks,
>
> Chris