Re: Problem loading to Timestamp column using SQL Loader

Hi!

Since Oracle converts a date even without time part, maybe sqlloader doesn't read the time part at all. Try defining the column (in sqlloader ctl file) as char(19) indicating that it should read 19 chars. BTW is the flat file separated, of fix length?

goforlinux2002_at_yahoo.com (Linux guy) wrote in message news:<290ea8c6.0211131759.36b76bf6_at_posting.google.com>...
> Hello ,
>
> I have data to be loaded to an Oracle table. The data is in a flat
> file and this data has been unloaded from an Informix database. The
> loading is fine but for one problem. The 'time' part of the TimeStamp
> field gets the value of 00:00:00 though there is a valid time in the
> DateTime field.
>
> The definition in the control file for this column is -
> BASETS "to_date(:BASETS,'YYYY-MM-DD HH24:MI:SS')"
>
> The data for this column is -
> 2002-11-10 09:00:48
>
> So, what could be the problem? any pointers? the 'date' portion of the
> field is loaded corrctly, but the 'time' portion is not.
>
> Thanx in advance for your help.
Received on Thu Nov 14 2002 - 06:09:37 CST