Trying to convert a number of '19760109' to a date field in Oracle. When I use the StringToDate function with map of '%yyyy%mm%dd' I get the following error message -
APT_CombinedOperatorController,0: Data string ' 1976010' does not match format '%yyyy%mm%dd': an integer was expected to match tag %yyyy.
You can see from the message that it looks like it has truncated the incoming field losing the last digit. Has anyone seen this before, or have I made an error with my mapping?
![Confused :?](./images/smilies/icon_confused.gif)