im getting this error "Syntax error converting datetime from character string" when im trying to insert values into the table in sql server 2000....here is hw my code goes...

insert into vw_student(RegNo,StudID,StudName,FathName,Sex,DOB,Department,DOJ,Yr,ContactNo)values('0001','1101','Abilash','Ramankutty','Female','1989-02-03','B.com','1styear','2006-06-16','90451299098')

pls help me in solving dis....

Recommended Answers

All 2 Replies

kindly post your complete SQL statement.

propably the dates arenot in the correct format. try using sql parameters it will help you alot

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.