Re: How to format time invervals?

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: 3 Apr 2003 04:17:35 -0800
Message-ID: <1075eb85.0304030417.1128dff2@posting.google.com>

Hallo Lothar,

l.armbruester_at_vertriebsunion.de (Lothar Armbrüster) wrote in message news:<35559896.0303312338.50e01255_at_posting.google.com>...
> Hello out there,
> I'm trying to format some datetime invervals:
>
> select
> to_char(numtodsinterval(elapsed_seconds,'SECOND'),'DDD HH24:MI:SS')
> from
> v$session_longops where rownum<10;
>

> The Oracle docs don't give any hint how to format these intervals.
> Obviously, the format models for the date datatype don't work for intervals.
>

i think you can't format the result of numtodsinterval, it is a varchar. The only way i see is something like that

substr(numtodsinterval(elapsed_seconds,'SECOND'),12, 8) or

substr(numtodsinterval(elapsed_seconds,'SECOND'), 8, 12)

Then you get "hh24:mi:ss" or "ddd hh24:mi:ss".

hth
Kay Received on Thu Apr 03 2003 - 06:17:35 CST