title: Is there any way to convert a date string with short monthname to datetime/date?
body: <p>I have to convert dates in the form '2017-Oct-23' to the date or datetime format in sql server. How can I do that? Is there a builtin function or do i need to use case in combination with convert?</p>