Convert date to sql date

1

I have 2 tables I need to join one has a proper sql datetime field and one has a date like 17-May-2015
How can I convert dates like dd-monthname-yyyy to a sql date?

2 
select CAST('17-May-2015' as datetime)
1 Like