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
Reading a dat file and loading into oracle table
Moderators: chulett, rschirm, roy
Reading a dat file and loading into oracle table
Thanks ,
Manoj
Manoj
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.