I am trying to insert a row in the database but I am getting data conversion error, it was working fine earlier.
Can someone please advise why it should not work?
I have used the following statement to add a record in the table
INSERT INTO LearnItResults (CustomerID, TestID, GiftCodeID, StartTime)
and i have got the following error message
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
ResultID int Unchecked
CustomerID int Checked
TestID nvarchar(50) Checked
GiftCodeID nvarchar(50) Checked
CreatedDate datetime Checked
StartTime datetime Checked
EndTime varchar(50) Checked
IsCompleted bit Checked