hi....

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....

kindly post your complete SQL statement.

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