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

[vb_dba]

Assuming your string is always in the same format, you could try out something like this:

Select Convert(smalldatetime, SubString(field, Charindex(' ', field, 0) + 1, Len(field)), 101)

[sagey]

ended up using something similar

 convert(smalldatetime, substring(@datestring,4,len(@datestring) -3))