Re: Converting minutes to minutes:seconds

Thanks, it's exactly what i was looking for...

stormbox_at_my-deja.com a crit :

> Hello,
>
> 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 Thu Oct 26 2000 - 00:21:11 CEST