MySQL Date Functions on 0000-00-00 Date Posted on May 5, 2010 by Leo When working with dates that are 0000-00-00, it will always return a null as by default it is considered an invalid date.