I am getting this error while converting stringtodate. source is .csv file and datatype is varchar have to keep date in oracle target.
using the ds version 8.1
I am using the code: StringToDate(SRC.DATE,'%mm/%dd/%yyyy')
getting resulet like **************
APT_CombinedOperatorController,0: Data string '11/2/2007' does not match format '%mm/%dd/%yyyy': the value for tag %dd has fewer characters than expected.
any advise!
StingtoDate
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: StingtoDate
using this format would solve the issue
Code: Select all
StringToDate(SRC.DATE,'%m/%d/%yyyy')
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: StingtoDate
using this format would solve the issue
Code: Select all
StringToDate(SRC.DATE,'%m/%d/%yyyy')
Re: StingtoDate
what is the format i can use if i need to keep the date like 19 sep 2008.
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers