CODE EXAMPLE FOR SQL

mysql update all record removing 2 hours from column

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