I have a date field in my table which is of the type varchar. It's in the format '15-jul-2015'. I want to convert it to date type in sql. The other questions where I looked for an answer didn't have answers to my perticular case. If the answer was there I couldn't find/understand it. I am new to sql and will really appreciate a detailed solution.