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 format not working...

to_date format not working...

From: Roy D. Mercer <wb5wzm_at_flash.net>
Date: Mon, 04 Dec 2000 21:13:36 GMT
Message-ID: <4OTW5.26520$6W1.1565809@news.flash.net> 






I have a column called time and set up as varchar2(8). It stores the time as
08001700.  When I create the report I want the time shown in this format:
08:00-05:00pm.  I have not been able to get this format to work
successfully.  I appreciate any help given. Thanks.
Received on Mon Dec 04 2000 - 15:13:36 CST












Original text of this message













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