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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
