• I prefer this method (sql 2008 + )

    SELECT CONVERT(DATE,'Jul 24 2013 8:05AM')

    Gives the result:

    2013-07-24

    [font="Times New Roman"]There's no kill switch on awesome![/font]