있었는데요 없었습니다

#DATE_FORMAT - NOT NEEDED FOR COMPARISON HERE. 
#IT CONVERTS TO A DATETIIME VALUE INTO A STRING: 
#A GOOD USE FOR STRING COMPARISON. 
SELECT i.ANIMAL_ID, i.NAME 
FROM ANIMAL_INS AS i
JOIN ANIMAL_OUTS AS o 
ON i.ANIMAL_ID = o.ANIMAL_ID 
WHERE i.DATETIME > o.DATETIME 
ORDER BY i.DATETIME;

SELECT i.ANIMAL_ID, i.NAME 
FROM ANIMAL_INS as i
JOIN ANIMAL_OUTS as o 
ON i.ANIMAL_ID = o.ANIMAL_ID 
WHERE DATE_FORMAT(i.DATETIME, '%Y-%m-%d') > DATE_FORMAT(o.DATETIME, '%Y-%m-%d') 
ORDER BY DATE_FORMAT(i.DATETIME, '%Y-%m-%d')