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 -> time conversion

time conversion

From: Shawn Bernard <shawn.bernard_at_mci.com>
Date: Wed, 17 Feb 1999 20:04:47 GMT
Message-ID: <36CB2110.6A213069@mci.com> 





I am coding in PL/SQL and i need to take a number (ranging from 0 to 23)
and convert it to the appropriate hour.  For example: 4 ==> 4:00 AM (or
4 AM), 14 ==> 2:00 PM



I can't seem to get the TO_DATE to work.  Does anyone have a solution?



Thanks,



Shawn

Received on Wed Feb 17 1999 - 14:04:47 CST












Original text of this message













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