[wp-trac] [WordPress Trac] #46994: wp_privacy_anonymize_data( 'date' ) uses problematic "zero date" to anonymize

[WordPress Trac]

#46994: wp_privacy_anonymize_data( 'date' ) uses problematic "zero date" to
anonymize
--------------------------+-----------------------------
 Reporter:  jrchamp       |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Privacy       |    Version:
 Severity:  minor         |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 The conversation in #43535 seems like it should have resulted in a default
 like '1970-01-01 00:00:01' to match the minimal valid value of TIMESTAMP.
 Instead, it uses the "special zero date" 0000-00-00 00:00:00 which
 generates an error with the default strict modes in MySQL 5.7 and MySQL
 8.0. I'd also be fine with null, but I acknowledge that tables may be set
 to disallow null.

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