updating Error
update Database.dbo.tbl_Traditional_OR
set EntryDate=CONVERT(datetime, substring(BillNo,5,12), 112)
Where EntryDate is null
i found below error
Msg 241, Level 16, State 1, Line 19
Conversion failed when converting date and/or time from character string.
please help me. i am a fresher. i am using sql server 2014
update Database.dbo.tbl_Traditional_ORset EntryDate=CONVERT(datetime, substring(BillNo,5,12), 112)Where EntryDate is null i found below errorMsg 241, Level 16, State 1, Line 19Conversion failed when converting date and/or time from character string.please help me. i am a fresher. i am using sql server 2014 Read More
