select
CONVERT(varchar(11),convert(datetime,REPLACE('due_date'+''+'2012',' ','-'),104),6) from
tbSemesterConfigurationMaster
when i write this query it will gives me the error
Conversion failed when converting datetime from character string.how it can be solved please help me as soon as possible