How to convert string date into datetime fromat

Question

How to convert string date into datetime fromat i want to convert 30/07/2013 date into datetime format

Sanjeeb Lenka · Answer

if date is in dd/MM/yyyy format SELECT convert(datetime '30/07/2013' 103) if date is in mm/dd/yyyy format select CONVERT(date'07/30/2013'101) if date is in yyyy/mm/dd SELECT convert(datetime '2013/07/30' 120)

Iftikar Hussain · Answer

Hi Try like this select CONVERT(datetime'30/07/2013'103) Regards Iftikar