On Fri, Nov 08, 2002 at 11:20:02 -0700, Roberto Mello <[EMAIL PROTECTED]> wrote: > > Is there any way to make a timestamp difference operation not return an > interval? I'd like to get hours, minutes and seconds only, not the "1 day" > or whatnot.
When you take a difference of two timestamps, you are going to get an interval that does not have a year, month difference component. You can get the interval value in seconds by using extract(epoch from interval). You can then further manipulate this value to get hours, minutes and seconds. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
