Untitled

How to convert mmm d yyyy HH:MM[AM] to datetime in SQL? [closed]
convert(datetime, 'Aug  4 2011 12:00AM')

select convert(datetime, 'Aug  4 2011 12:00AM') as ConvertResult

ConvertResult
-------------
2011-08-04 00:00:00.000

select convert(datetime, 'Aug  4 2011 12:00AM', 100) as ConvertResult

ConvertResult
-------------
2011-08-04 00:00:00.000

convert(datetime, 'Aug  4 2011 12:00AM', 120)

declare @datestring varchar(30);
set @datestring = 'Aug  4 2011 12:04AM';

select convert(datetime,
    substring(@datestring, 8,4) + '-' +
    case lower(left(@datestring, 3))
        when 'jan' then '01'
        when 'feb' then '02'
        when 'mar' then '03'
        when 'apr' then '04'
        when 'may' then '05'
        when 'jun' then '06'
        when 'jul' then '07'
        when 'aug' then '08'
        when 'sep' then '09'
        when 'oct' then '10'
        when 'nov' then '11'
        when 'dec' then '12'
    end + '-' +
    right('00' + ltrim(rtrim(substring(@datestring, 5, 2))), 2) + ' ' +
    substring(@datestring, 13,50)
) as Converted;