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: to_date format

Re: to_date format

From: MattJ83 <mattjones_at_hotmail.co.uk>
Date: 21 Sep 2006 02:26:06 -0700
Message-ID: <1158830766.681791.148590@m73g2000cwd.googlegroups.com> 





On a closly related matter - i have managed to get the string to be
converted into a date.


2006082109        - 21/08/2006 09:00:00
2006082110        - 21/08/2006 10:00:00





however, when i read in a string such as:



2006082100



it is being converted to:



21/08/2006



the time is being left off completely. I thought as i stipulated
'YYYYMMDDHH24' in my code that is would output results from the 24hr
clock and so would interpret 00 as 00:00:00.
Received on Thu Sep 21 2006 - 04:26:06 CDT












Original text of this message













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