Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Converting minutes to minutes:seconds

Re: Converting minutes to minutes:seconds

From: Arie Mars <arie_at_pca-online.nl>
Date: Wed, 25 Oct 2000 09:12:31 +0200
Message-ID: <8t6168$e5k6l$1@reader2.wxs.nl> 






select TO_CHAR(FLOOR(minutes/60)) || ':' || TO_CHAR(MOD(minutes,60)) from
dual



i.e. when minutes is 867 it would return 14:27



Arie Mars


arie_at_pca-online.nl




dmany <dmany_at_axess.com> schreef in berichtnieuws
39F60E62.4589F89E_at_axess.com...


> 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 Wed Oct 25 2000 - 02:12:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US