I have input value in the file as varchar(10) as yyyymmdd /yymmdd , I got to insert into the oracle database as date field.
Before writing to table I am just converting the string to date format and writing to a file for testing purposes which is not working and job is aborting.Following the function used for conversion.
StringToDate(DSLink92.PROCESS_DATE, "%yyyy-%mm-%dd%" )
Any inputs greatly appreciated.
string to date conversion
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Now the function is working with some warnings
as below:
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine date_from_string data may have been lost
And I have the Null field value set to 1950-01-01 to the date fields in the column properties.
Is that the right way set Null properties on the target file side.
Thank you all.
as below:
APT_CombinedOperatorController(1),0: Conversion error calling conversion routine date_from_string data may have been lost
And I have the Null field value set to 1950-01-01 to the date fields in the column properties.
Is that the right way set Null properties on the target file side.
Thank you all.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm