StringToDate Error

cfuller · Post by **cfuller** » Thu Mar 18, 2010 5:38 am

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?

rohithmuthyala · Post by **rohithmuthyala** » Thu Mar 18, 2010 5:47 am

If you observe the error message there is a space coming in front of the string,trimming the string before the conversion can help.

cfuller · Post by **cfuller** » Thu Mar 18, 2010 6:00 am

Thanks Rohith...missed that space completely...