Problem loading to Timestamp column using SQL Loader

From: Linux guy <goforlinux2002_at_yahoo.com>
Date: 13 Nov 2002 17:59:09 -0800
Message-ID: <290ea8c6.0211131759.36b76bf6@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 Wed Nov 13 2002 - 19:59:09 CST