Notes This is separate from #25253, which covers CAST('0000-00-00 00:00:00' AS DATETIME). This issue is about date/time function behavior for zero/incomplete/invalid date strings. MySQL documentation ...