Configure Mysql to accept reset TIMESTAMP

Asked

Viewed 111 times

0

I’m migrating a database from SQL Server to the Mysql. On migration it gives error when it will popular tables on MYSQL TIMESTAMP.

Incorrect datetime value ( 2007-10-21 00:00:00.000000 )

When du um insert manual filling the hours, it inserts the value correctly. I can somehow configure the Mysql to always accept TIMESTAMP zero-hour 00:00:00.000000?

mysql timestamp

  • Don’t just put "0" in the "default" field? Look: https://i.imgur.com/dqOL3BV.png

  • Tried TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00' ?

No answers

Browser other questions tagged mysql timestamp

You are not signed in. Login or sign up in order to post.