Oracle date format
Posted: Fri Aug 01, 2003 9:34 am
Using DataStage version 6 and I have no experience with Oracle databases.
I am trying to insert a row in an Oracle table VIA AN ODBC stage. The Oracle table has a column with a 'date' format. How do I format the date field so that the insert works? I am currently getting the following message:
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver]Datetime field overflow. Error in parameter 7.
Where parameter 7 is:
TRANSMISSION_DATE="20030521"
Any help greatly appreciated.
I am trying to insert a row in an Oracle table VIA AN ODBC stage. The Oracle table has a column with a 'date' format. How do I format the date field so that the insert works? I am currently getting the following message:
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver]Datetime field overflow. Error in parameter 7.
Where parameter 7 is:
TRANSMISSION_DATE="20030521"
Any help greatly appreciated.