how to convert varchar value to datetime?

Vote count:

-3

I have a field "ContractDate" in my table in the format "20/06/2014". The data type of this field in my table is varchar(50).

I want to convert this varchar field into datetime format. Any idea ?

asked 1 min ago

user3563084

1