insert into student(firstname,lastname,dateofbirth,fathername,mothername,gender,height,weight) values('Raja','Sekar',CONVERT(datetime,'20-07-2011'),'Sekar','Radha','Male','5.58','70')
hi,
iam amudhan,
anyone please help me what mistake in a above query i got one error please rectify it...
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.
this is error