Convert varchar in mon-yy format to datetime in SQL server

Question

Is there an easy way to convert the date stored in varchar in mon-yy format (for example, "Feb-09") to datetime, which converts any invalid values ​​to null.

I am currently using string manipulation in conjunction with the case argument, but this is rather cumbersome.

Answer 1

For real values, you can just put a day on it, and this is the full date:

convert(datetime,'01-' + 'Feb-09',120)

Answer 2

It will do it.

SELECT convert(datetime,'01-' + 'Feb-09',120)

Answer 3

CONVERT( DATETIME, "Feb-09", 64, 7 )