Conversion failed when converting date and/or time from character string select app.[Pap_id], reg.[p_id],[p_name],[p_age],[p_gender],[p_mob : Conversion failed when converting date and/or time from character string.
"select  app.[Pap_id], reg.[p_id],[p_name],[p_age],[p_gender],[p_mob],[p_specificId],app.[ap_date],app.[reqst_txt]  from [dbo].[tblpatientReg] reg
inner join [dbo].[tblAppoinment] app on app.[P_id]=reg.[p_id] where app.[p_status]  =1   order by convert(date,app.[ap_date] ,105) asc"
