[wp-trac] [WordPress Trac] #41785: I don't think the default date "0000-00-00 00:00:00" is good idea in MySQL 5.7+

WordPress Trac noreply at wordpress.org
Sun Sep 3 13:15:35 UTC 2017


#41785: I don't think the default date "0000-00-00 00:00:00" is good idea in MySQL
5.7+
--------------------------+-----------------------------
 Reporter:  kmvan         |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.8.1
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 In MySQL 5.7+, the default date "1970-01-01 00:00:00" is better than
 "0000-00-00 00:00:00".
 It will show a invalid date when date is "0000-00-00 00:00:00" in MySQL
 5.7+

 Shows: '''Invalid default value for 'post_date'.'''

--
Ticket URL: <https://core.trac.wordpress.org/ticket/41785>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list