Reading a dat file and loading into oracle table

daramanoj · Post by **daramanoj** » Fri Jul 30, 2010 12:45 am

Hi ,

I am reading data from a .dat file which have 3 columns and 1 row in which the data is like this

''ABCD,20/03/2010,hghui3hgk3o3io''

so my job is to load this into oracle table ,while doing this the date column is not getting inserted properly it shows like "20/01/2028 08:00:00.000000"
datatype is date for this column

so please can anyone suggest me on this problem.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Fri Jul 30, 2010 1:27 am

Oracle is ... different.

You must ensure that the date you provide to Oracle matches the default date picture Oracle uses (or override that with appropriate functions).

Oracle DATE data type always includes a time component. Therefore a query against the table is likely to return the time component as well, unless you specify otherwise with an appropriate function such as TO_CHAR.

daramanoj · Post by **daramanoj** » Fri Jul 30, 2010 3:21 am

oh Thanks

i have changed the input date format its working.
:D