[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]

#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:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.8.1
 Severity:  normal        |  Resolution:  duplicate
 Keywords:                |     Focuses:
--------------------------+------------------------
Changes (by dd32):

 * status:  new => closed
 * resolution:   => duplicate
 * milestone:  Awaiting Review =>


Comment:

 Even in MySQL 5.7 if the SQL Mode is set correctly, it's supported.

 Although we wish a better default was chosen, lots of plugins expect this
 date format and there's not a lot we can do.
 For consistency, this was discussed previously in #8857 and where it
 should be brought up.

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