Timestamp issue inserting into Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue May 31, 2005 3:44 pm
What is the auto genereated SQL for Insert comming up?
Use the following for the timestamp field at the insert statment if you use User defined SQL
Where :1 is the first field if its the timestamp datatype.
Use the following for the timestamp field at the insert statment if you use User defined SQL
Code: Select all
timestamp':1'
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 9
- Joined: Tue May 31, 2005 3:44 pm
I'm using Oracle Enterprise Stage with LOAD option hence uanble to use user defined queries.
As I have said earlier, to test the job I have hardcoded the timestamp value in the transformer.
StringToTimestamp("2007-10-10 10:10:10", "%yyyy-%mm-%dd %hh:%nn:%ss)
The records are getting rejected in the oracle enterprise stage. I looked into the bad file created by the Oracle Enterprise(sqlldr) and the timestamp value in it is showing up as "10/10/2007 10:10:". I am not sure why the value of seconds is missing. Is there any other option I need to pass or is there any other enviroment variable which is causing this issue?
As I have said earlier, to test the job I have hardcoded the timestamp value in the transformer.
StringToTimestamp("2007-10-10 10:10:10", "%yyyy-%mm-%dd %hh:%nn:%ss)
The records are getting rejected in the oracle enterprise stage. I looked into the bad file created by the Oracle Enterprise(sqlldr) and the timestamp value in it is showing up as "10/10/2007 10:10:". I am not sure why the value of seconds is missing. Is there any other option I need to pass or is there any other enviroment variable which is causing this issue?