i have one doubt for sql insert statement

Amudhan Kuppan

8y734SQL

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manav Pandya8y ago
Accepted answer
Hello

You are doing almost correct thing but one thing is missing :

You should specify century , that specify format of an converted date

Please try below format :
select CONVERT(datetime,'20-07-2011' , 105)
And output will be like :
2011-07-20 00:00:00.000

You can try some other option as in given link :

https://www.w3schools.com/sql/func_sqlserver_convert.asp

Same way you can use CAST() as well :
SELECT CAST('2011-07-20' AS datetime);
Go through :

https://www.w3schools.com/sql/func_sqlserver_cast.asp

I hope it helps

Thank
Nitin Sontakke8y ago
I have kept the following link in the Favorites, you can do the same.

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql
sudipta sanyal8y ago
Hi Amudhan
Please Visit
https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/
Amudhan Kuppan8y ago
ok thank you 103 and 101 means cannot understand please tell me sudipta sanyal
sudipta sanyal8y ago
Try with this
insert into student(firstname,lastname,dateofbirth,fathername,mothername,gender,height,weight) values('Raja','Sekar',convert(varchar, convert(datetime, '20-07-2011', 103), 101),'Sekar','Radha','Male','5.58','70')