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
  phils AT caerllewys DOT net
  phil AT co.ordinate DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users