Re: how to get number of minutes?

[Casey Duncan <casey@xxxxxxxxxxx>]

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