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

Home -> Community -> Mailing Lists -> Oracle-L -> Date conversion question

Date conversion question

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 3 Oct 2007 15:44:21 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E02AA4@ex2003.metratech.com> 





Hi,



We have a flat file that contains a column and the values are stored as:
991123 


421 


60823 


0


70930



Now we are moving data from flat file to table and this column will be
inserted into Date dataype column, What is the way to insert into this
table and avoid "ORA-01821: date format not recognized" errors.



Thanks


--Harvinder




--



http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 03 2007 - 14:44:21 CDT












Original text of this message













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