Amudhan Kuppan

Amudhan Kuppan

  • NA
  • 378
  • 29.9k

i have one doubt for sql insert statement

Mar 5 2018 1:15 AM
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  

Answers (5)