How to convert mmm d yyyy HH:MM[AM] to datetime in SQL?
I am going nuts with datatime and MS SQL.

i have (example) Aug  4 2011 12:00AM

how do I converto to a datetime (or smalldatetime) type.

    convert(datetime, 'Aug  4 2011 12:00AM') doesn't work.

Thanks.


How to convert mmm d yyyy HH:MM[AM] to datetime in SQL?
===

I am going nuts with datatime and MS SQL.

i have (example) Aug  4 2011 12:00AM

how do I converto to a datetime (or smalldatetime) type.

    convert(datetime, 'Aug  4 2011 12:00AM') doesn't work.

Thanks.

