sql, turn string into date

[sagey]

I have a string of a date in my sql server database:

'wed feb 16 2005'

How (in sql) do i turn it into a date formatted like this:

2005-02-16 00:00:00.000