inserting date in datetime column

Hi:

I am inserting date in datetime column and getting error message.
message is - Syntax error converting datetime from character string.

insert into table1
Values (0,0,'0','0','0','0','0','0','0','0','5/1/2004','0','0')

Any help!
Thanks,
sripri96
sripri96Asked:
Who is Participating?
 
rafranciscoCommented:
Make sure that the columns in Table1 matches the list in your VALUES clause.  To be safe, it's better to specify the column names in your INSERT clause to make sure that the VALUES match.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.