I HAVE 2 FIELD TIME START AND END TIME DOES NOT CALCULATE WELL TIME
SELECT a.codprogramacion
AS mensaje FROM 'programacion' a JOIN dias b ON a.'iddia' = b.codigodia join gestion c on a.idgestion = c.codigogestion
JOIN horario d ON a.idhorario = d.codigohora
JOIN materias f on a.idmateria = f.codigomateria
WHERE b.nombredias LIKE CONCAT('%',p_dia,'%')
and ((time(p_en) >= d.entrada AND time(p_en) < d.salida ) OR (time(p_sa) > d.entrada AND time(p_sa) < d.salida) OR (time(p_en) < d.entrada AND time(p_sa) > d.salida )
)
AND 'idgestion' = p_ges
and f.CARRERA = p_Ca
AND f.SEMESTRE = p_semestre