Re: Converting minutes to minutes:seconds

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Tue, 24 Oct 2000 22:02:02 -0500
Message-ID: <39F64D2A.EE375208@ntsource.com>

Suppose you have 5000.345 minutes and you want to convert this to 5000:20.7, then the following might help:

SQL> select to_char(trunc(5000.345)) || ':' || to_char((5000.345-trunc(5000.345))*60) from dual;

TO_CHAR(T

---

5000:20.7

Frank Hubeny

dmany wrote:

> Hi,
>
> I'm looking for an easy way (Oracle tool, sql or plsql) to convert a
> number of minutes in minutes:second format.
>
> Any help will be appreciated...
  Received on Tue Oct 24 2000 - 22:02:02 CDT