1
09:30:41'::timestamp), 'HH24:MI:SS');
Result:
14:28:19
It just gives me the offset of hours, min, seconds on that 14th day.
The result I'm looking for is: 350:28:19
What am I doing wrong, or how can I get this desired output? Thanks,
--
Graham Davis
Re
ows a better/proper way to get this result, let me know.
Thanks,
Graham.
Graham Davis wrote:
Hi,
I'm trying to format the output of a time interval so that it displays
as HH:MM:SS no matter how many days it spans. So for instance, an
interval of 2 days 4 hours and 0 minutes w
x27;s not really enough time to think through the consequences
now. I'd like to experiment with it for 8.3 though.
regards, tom lane
--
Graham Davis
Refractions Research Inc.
[EMAIL PROTECTED]
---(end of broadcast)-
