Re: date intervals

    As far as I know, the correct spelling for the date format should be 'HH:MI:SS', as 'HH:MM:SS' would display the month instead of minutes.

       Eduardo Pimenta.

In article <3711C0D8.851ADD9D_at_india.hp.com>,   "G.H VITTAL" <vittal_at_india.hp.com> wrote:
> You can use date datatype
>
> select to_char(sum(interval),'HH:MM:SS') from table;
>
> just test this format
> by giving select to_char(sysdate,'HH:MM:SS') from dual
>
> regards
> vittal
>
> Eric wrote:
>
> > I need to keep track of how long various system process execution times. In
> > my source code, I have an object that knows the start time and the end time
> > of a process, and I have an Interval object that can calculate the
> > difference between the two.
> >
> > Ideally, I want to be able to store one value representing this interval in
> > Oracle (7.3 server), which I can later retieve and format as
> > hour:min:seconds in Brio Query. I want to be able to total these values as
> > well, and display the total formatted as hour:min:seconds as well.
> >
> > Can I do this? What Oracle datatype should I use, and how should it be
> > populated?
> >
> > Any advice much appreciated!
> >
> > Eric
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 12 1999 - 11:31:58 CDT