Data truncation: Incorrect datetime value in MySQL

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

18 thoughts on “Data truncation: Incorrect datetime value in MySQL

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

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

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

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

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

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

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

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