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

Home -> Community -> Usenet -> c.d.o.tools -> to_date function won't format properly

to_date function won't format properly

From: Roy Mercer <wb5wzm_at_flash.net>
Date: Mon, 04 Dec 2000 06:10:01 GMT
Message-ID: <3A2B5187.1B7F664D@flash.net> 






I have a column (time) as varchar2(8) and it stores time in military
format.  ie. 08001700.  The first 4 digits are the start time and the
last four are the ending time.  In my report I want the time to display
like this 08:00-05:00pm.  I know to_date should be the method but I have
not been successful in formatting it properly. Thanks for the help.
Received on Mon Dec 04 2000 - 00:10:01 CST












Original text of this message













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