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: Number into Time Format

Re: Number into Time Format

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Wed, 06 Dec 2000 03:28:16 GMT
Message-ID: <90kbob$bbi$1@nnrp1.deja.com> 






to_char(to_date(trunc(sysdate) + 1.5 / 24, 'HH24:MI')



In article <vokq2t0657ikf09i8323aomskrmu75f86j_at_4ax.com>,
  NeedaHoliday wrote:


> How can I turn 1.5 into 1:30 using an Oracle function.

>

> Thanks.

>





Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Tue Dec 05 2000 - 21:28:16 CST












Original text of this message













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