sql server convert string to datetime

Question

I have this string: '30/05/2010', and I would like to enter it to a smallDatetime field. In the database it should look something like this 2010-05-30 15:33:25 Any Idea how?

TY

Answer 1

use

select convert(smalldatetime,'30/05/2010',103)