Hi,
I have a flat file input with a datetime column. The input data will have the format mm/dd/yyyy hh:mm:ss. The target is oracle database. When I tried to load data, I am getting the error Datetime field overflow. I have chosen timestamp as the datatype in DataStage and date in the target Odbc stage. It is a direct load. Please let us know how to populate timestamp value in Oracle.
if you are able to define the format of the field in the flat file,
use YYYY-MM-DD HH:MM:SS
this is the format that datastage automtically recognizes for timestamp fiels.
The field in the oracle database can be date (which also accepts time-indications). You don't have to specify any formats using these settings.
You can use DateTimeStampToOraOCIWithTime(DateGenericToTimeStamp(link.inputcolumnname)) in the derivation - it should insert the right timestamp in the oracle target column.. This works for me