Breaking News: Grepper is joining You.com. Read the official announcement!

Invalid default value for 'post_date' ignore this error

Lokesh003Coding answered on December 22, 2020 Popularity 7/10 Helpfulness 5/10

answer Invalid default value for 'post_date' ignore this error

Invalid default value for 'post_date' ignore this error

Comment

if you generated the script from the MySQL workbench.

	The following line is generated
    
    SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
    Remove TRADITIONAL from the SQL_MODE, and then the script should work fine

Else, you could set the SQL_MODE as Allow Invalid Dates
	
    SET SQL_MODE='ALLOW_INVALID_DATES';
    
reference :
https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field

Popularity 7/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: default-value ignore this whatever

Link to this answer
Share Copy Link

Contributed on Dec 22 2020

Lokesh003Coding

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Invalid default value for 'post_date' ignore this error

Contents

More Related Answers

Invalid default value for 'post_date' ignore this error

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.