Hi
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?
StringToDate Error
Moderators: chulett, rschirm, roy
StringToDate Error
Regards
Chris Fuller
"Reality is what refuses to go away when you stop believing in it"
Chris Fuller
"Reality is what refuses to go away when you stop believing in it"
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India