MySql Trim DateTimes

Time portions of datetimes from time to time get inserted or updated into database columns that are intended to be purely date only.

The TIME and MAKETIME functions can fix this, with for example you have a database table with two date columns {Arrival, Departure}

UPDATE TargetTable
set Arrival = DATE(Arrival),
    Departure = DATE(Departure)
WHERE (TIME(Arrival) != MAKETIME(0, 0, 0) OR TIME(Departure) != MAKETIME(0, 0, 0));