trigger to delete records from table in mysql after 2 days code example

Example: mysql update all record removing 2 hours from column

UPDATE datetimes
SET datetime = DATE_ADD(datetime,
                        INTERVAL (15 - HOUR(datetime)) HOUR);