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

Posted on 2011-05-06
Last Modified: 2012-05-11

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

Question by:ajayvegesna02

    Accepted Solution


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

    now it's executing fn....

    Author Closing Comment

    when i am looking the problem deeply ... i got this solution....

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now