A client gave us a CSV file with several dates throughout. I imported the data into SQLanywhere 10 as char data.

We need to be able to convert the string value date field into the proper format. The problem is that the format they are in is: 8/14/2012. Thats right, there is no leading 0 in the month or day.

The sybase convert function SyBooks Online won't work, as it doesnt even support a date in d/m/yyyy format! Any suggestions on how to get the conversion to work?