Thread: how to get number of minutes?

how to get number of minutes?

From
"Chris Hoover"
Date:
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

Re: how to get number of minutes?

From
Casey Duncan
Date:
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