i am trying to load a csv file into a table ...
[DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field overflow.
i am getting the following error .... the date field is in M/DD/YYYY FORMAT AND the date format for oracle database is DD-MON-YY
... im just starting my first task in datastage so any help wuld be appreciated
date error
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
ODBC protocols require dates to be in YYYY-MM-DD format (according to the ISO 8601 standard). This requirement overrides the Oracle date picture and the actual format of your date.
Change your date format, for example using
ODBC protocols require dates to be in YYYY-MM-DD format (according to the ISO 8601 standard). This requirement overrides the Oracle date picture and the actual format of your date.
Change your date format, for example using
Code: Select all
Oconv(Iconv(InLink.MyDate, "DMDY"), "D-YMD[4,2,2]")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.