I want to convert the datatype from char to datetime in th sql server table.
But i am not able to convert .
I am getting the following error.

Msg 241, Level 16, State 1, Line 2
Conversion failed when converting datetime from character string.

But I need to convert the same....as i have done teh same long back.
It would be of very great help, if you suggest me the solution for the same.

Thanks in adv,