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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Return minutes as date datatype

Re: Return minutes as date datatype

From: Craig & Co. <crb_at_amsa.gov.au>
Date: Thu, 22 Jul 2004 15:22:22 +1000
Message-ID: <40ff4f51$0$51369$c30e37c6@lon-reader.news.telstra.net> 





>   1* select To_Char(sysdate,'HH24MI') from dual

> SQL> /


>

> TO_C

> ----

> 1725

>

> Seems numeric enough to me?




That's the way I'd do it.



Craig.
Received on Thu Jul 22 2004 - 00:22:22 CDT












Original text of this message













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