Re: Converting minutes to minutes:seconds
From: <stormbox_at_my-deja.com>
Date: Wed, 25 Oct 2000 07:59:35 GMT
Message-ID: <8t63t6$pe6$1_at_nnrp1.deja.com>
Date: Wed, 25 Oct 2000 07:59:35 GMT
Message-ID: <8t63t6$pe6$1_at_nnrp1.deja.com>
Hello,
[Quoted] If you have a date you can display it in minutes:seconds format by converting it to a character field eg
select to_char(sysdate,'MI:SS') from dual;
If you just have a numeric column with minutes then you won't know how many seconds there are so you will need something like:
select to_char(num_column)||':00' from dual;
Regards,
Dave
In article <39F60E36.8A8EBD4A_at_axess.com>,
dmany <dmany_at_axess.com> wrote:
> Hi,
>
> I'm looking for an easy way (Oracle tool, sql or plsql) to convert a
> number of minutes in minutes:seconds format.
>
> Any help will be appreciated...
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 25 2000 - 09:59:35 CEST