I found this warning (Incorrect date value: '2024-11-07 22:00:00' for column 'fecha' at row 1) on valid dates The problem cames because I defined a function as: FUNCTION CheckDateTimeHoliday(fecha DATE,....) RETURNS tinyint(1)

but it should be defined with the correct type (DATETIME) FUNCTION CheckDateTimeHoliday(fecha DATETIME,....) RETURNS tinyint(1)

The first function did not give any error, but I found the warning on any SELECT with the incorrect funcion define