Team, I am doing bulk load on oracle. It has time stamp column. In DB NLS_TIMESTAMP_FORMAT ser as 'dd-MMM-YY HH:MI:SS'. Datastage I tried to change default time stamp format as 'dd-MMM-yy HH:MI:SS'. when I write to Dataset and see it is still in 'dd-mm-yyyy hh:mm:ss' format .
Because of it, Bulk load fails stating ORA-01821 date format not recognized. Please advice how can we change time stamp to DB format in Datastage.
Timestamp Column issue in bulk load
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage does not follow the Oracle standard for timestamp format strings. But, if your data are already data type timestamp, you should not be fiddling about with format strings in any case. Only if you have to use StringToTimestamp() or similar functions.
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.