Data truncation: Incorrect datetime value in MySQL

15 Dec

Message Error in MySQL:
“Data truncation: Incorrect datetime value: ‘1969-12-31 16:00:00’ for column ‘LAST_LOGIN’ at row 1”


Now, open the my.ini file located at c:program files/MySQL/MySQL
Server X.x/my.ini.
Add a # at the begining of the line: sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

sql_mode=” on the next line and save the file.
restart mysql


Posted by on December 15, 2009 in MySQL Server


18 responses to “Data truncation: Incorrect datetime value in MySQL

  1. Agence de traduction

    October 18, 2011 at 8:41 PM

    Thanks a lot, you know I have been going through pages for details about this topic for ages and yours is the most complete I have stumbed upon up to now. Entreprise Traduction

  2. karl

    March 20, 2013 at 8:21 AM

    Really curious if you have any other advice. I moved a DB from one server to another, and now any record operation with dates gives me issues. I tried your suggestion, no go.

    the difference is my date value appears blank, as you will see from two single quotes:

    Data truncation: Incorrect datetime value: ” for column ‘userTable’ at row 1

    • sochinda

      March 20, 2013 at 10:21 AM

      So did you follow my instruction?

      • karl

        March 20, 2013 at 10:39 AM

        Yes, it did not work.

  3. シャネル アリュール

    May 11, 2013 at 10:30 AM


  4. Web Profits Work From Home

    August 2, 2013 at 11:56 AM

    Hello there I am so happy I found your weblog, I really found you by error, while I was researching on Bing for something else, Anyways I am here now and would just like
    to say cheers for a remarkable post and a all round
    thrilling blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the excellent job.


    March 27, 2014 at 4:01 AM

    What’s up i am kavin, its my first occasion to commenting
    anyplace, when i read this post i thought i could also make comment due to this sensible post.


    May 15, 2014 at 10:03 AM

    Very interesting points you have mentioned , appreciate it for putting up.
    “Lefty Wise guy dont carry wallets, they carry their money in a roll….beaner on the outs”
    by Donnie Brasco.

  7. bigfoot sightings

    May 30, 2014 at 8:23 AM

    What’s Taking plaϲe i ɑm new to this, I stumbled upon this I
    hazve found It positively սseful and iit hɑs helped me oout loads.
    І’m hoping to contribute & aid otɦeг users lke its helpwd mе.

    Good job.


    June 5, 2014 at 3:08 PM

    bookmarked!!, I like the blog!

  9. download hack tool

    June 12, 2014 at 7:18 AM

    This might be a ssubject matter this is near to my heart…

    Cheers! Exactly where are your contact details though?

  10. Ask Angels

    June 20, 2014 at 4:29 PM

    I feel this is among the such a lot significant information for
    me. And i am glad reading your article. However waanna observation on some basic issues, The web site style is great, thee articles is in point of
    fact nice : D. Good activity, cheers

  11. Archangel Metatron

    June 20, 2014 at 4:37 PM

    Pretty section of content. I just stumbled upon your blog
    and iin acession capital to say that I get actually enjoyed account your blog posts.

    Any way I’ll be subscribing on your auggment or even I success you get entry to persistently fast.

  12. Titus

    July 29, 2014 at 1:53 AM

    What’s up, after reading this awesome post i am too delighted to share my knowledge here with friends.


    July 29, 2014 at 10:18 AM

    Can I simply just say what a relief to discover
    a person that actually knows what they are discussing on the net.
    You certainly realize how to bring ann issue to light and
    make it important. More and more people must read this and understand this side of the story.
    It’ssurprising you aren’t more popular given that you definitely have the gift.

  14. visit Best Hybrid Bikes Available

    August 15, 2014 at 10:09 AM

    Great post. I was checking continuously this blog and I am impressed!
    Very helpful information specially the last part 🙂 I care for such info much.
    I was seeking this certain info for a lonjg time.

    Thank you and best of luck.

  15. hosting in india

    August 21, 2014 at 7:48 PM

    My partner and I stumbled over here from a different
    web address and thought I might as well check things out.
    I like what I see so i am just following you.

    Look forward to looking into your web page repeatedly.

  16. fappening free download

    September 21, 2014 at 7:24 PM

    Attraction is is something you must do to make your ex girlfriend or ex boyfriend feel towards you.
    Now, saying “I’m sorry” is not the ultimate way
    to handle a breakup. Chatting records between friends
    are required to be added backup encryption, which
    will ensure the safety of key information and unrelative people
    can not get access to the important and secret files.
    I kept their interest and I had not even taken my clothes off.

    What you should do at this point is to get the attention of
    your ex boyfriend or ex girlfriend.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: