On 07/16/17 15:11, Kern Sibbald wrote: > Hello Phil, > > According to the documentation in both MySQL and MariaDB, I can use > "0000-00-00 00:00:00".
Yes - prior to MySQL 5.7, or if you change MySQL 5.7's default SQL_MODE. The default SQL_MODE in 5.7 includes NO_ZERO_DATE,NO_ZERO_IN_DATE. Remove those, and it'll work just fine in MySQL 5.7. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users