I read a CSV with
BULK INSERT. In this CSV I have dates formatted with
What is the best way to convert this varchar to a date column?
So far I only found solutions using the in-built formats. None of these formats match my format. Also note that the missing
day should get the value
01. This leads to following conversion:
Jan 2016 ->
2016-01-01 (format of second date doesn't actually matter. I normally use