SQLTeam.com | Weblogs | Forums

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)