MySQL Incorrect datetime value: ‘0000-00-00 00:00:00’

update wp_posts set post_modified = post_date, post_modified_gmt = post_date_gmt where  CAST(post_modified AS CHAR(20)) = '0000-00-00 00:00:00'

http://www.waitingfy.com/archives/4776

4776

Leave a Reply

Name and Email Address are required fields.
Your email will not be published or shared with third parties.