i have doubt for stored procedure

Amudhan Kuppan

8y721SQL

hi,

iam amudhan

anyone please help me

iam execute stored procedure query i got some error please help me

ALTER Procedure [dbo].[InsertStudentrecord]

(

@ID int,

@FirstName Varchar(50),

@LastName Varchar(50),

@DateOfBirth datetime,

@FatherName varchar(50),

@MotherName varchar(50),

@Gender varchar(50),

@Height decimal(18,0),

@Weight decimal(18,0)

)

Begin

Insert into Student (ID,FirstName,LastName,DateOfBirth,FatherName,MotherName,Gender,Height,Weight)

Values(@ID,@FirstName,@LastName,@DateOfBirth,@FatherName,@MotherName,@Gender,@Height,@Weight)

End

this is my query iam executing the query i will get completed successfully after i will insert the data in a table i got one error please rectify it

Msg 8114, Level 16, State 5, Procedure InsertStudentrecord, Line 2

Error converting data type nvarchar to datetime.

(1 row(s) affected)

this is error

4 Replies

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

Manav Pandya8y ago
Accepted answer
Hello

Problem is only with Dateofbirth column , thats why you facing this error

It shows invalid converzation from string to datetime

You can follow conversion possibilities for c# code below :

http://net-informations.com/q/faq/stringdate.html

http://www.c-sharpcorner.com/UploadFile/manas1/string-to-datetime-conversion-in-C-Sharp/

Thanks
Amudhan Kuppan8y ago
iam not ask insert a single data for column dob....iam asking stored procedure for insert a data
Manav Pandya8y ago
Hello

You can try convering datetime as below :
SELECT CONVERT(DATETIME , @DateOfBirth ,103) // Do not use 104
Let me know if still you face this issue
Thanks
Amit Gupta8y ago
If you are calling sp from code behind, pass the datetime variable, it seems you are passing string datetime, this was the issue. Or if you are testing on sql them convert your string datatype to valid datetime datatype by ysing convert function