[Solved] i am getting this error saving the data in Sql Server “conversion failed when converting date and/or time from character string.”. below is my code:

by


Change insQury to

string INSQURY = " insert into  [MTS_TV_RO_TC_FINAL] ([DATE],[CAPTION_NAME],[IST],[DURATION],[AMOUNT],[CRID],[JOB_CODE],[AGENCY_CODE],[STATUS],[TBAND_IN],[TBAND_OUT],[DATE_FROM],[DATE_TO],[CREATE_DATE],[USER_NAME],[REMARKS],[Ro_Name],[Job_Name])   SELECT [DATE],[CAPTION],[IST],[DURATION],[AMOUNT],[CRID],'" + TJOBCODE + "',[Agency_code],[STAT],[TBAND_IN],[TBAND_OUT],COMP_FROM, COMP_TO,GETDATE() AS DT,'" + Global.uname + "' ,[REMARKS],'" + TRo_Name + "','" + TJob_Name + "' FROM " + tmptvrlbktbl + " ORDER BY DATE";

If COMP_FROM and COMP_TO are dates already you don’t need to surround them with single quotation marks.

4

solved i am getting this error saving the data in Sql Server “conversion failed when converting date and/or time from character string.”. below is my code: