Member Avatar for Sinduja Arun

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

  • 3 Contributors
  • 2 Replies
  • 157 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Mariandi
Member Avatar for debasisdas

kindly post your complete SQL statement.

Member Avatar for Mariandi

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, networking, learning, and sharing knowledge.