update query to update the Date column in a table (MySql)

Hi,

I need Update query to update the Date column in a MySql table

i am using this Query to update the date in table

UPDATE table SET StartDate = '2011-20-04' WHERE MyID = 1 ;

But got this error message

Incorrect date value: '2011-20-04' for column 'StartDate' at row 1

can anyone pls help me????

Thanks,
Ajay
ajayvegesna02Asked:
Who is Participating?
 
ajayvegesna02Author Commented:
Sorry....

The format should be yyyy-MM-dd ..... instead of yyyy-dd-MM


now it's executing fn....
0
 
ajayvegesna02Author Commented:
when i am looking the problem deeply ... i got this solution....
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.