Answers for "mysql update all record removing 2 hours from column"

SQL
0

mysql update all record removing 2 hours from column

UPDATE datetimes
SET datetime = DATE_ADD(datetime,
                        INTERVAL (15 - HOUR(datetime)) HOUR);
Posted by: Guest on May-14-2021

Code answers related to "mysql update all record removing 2 hours from column"

Code answers related to "SQL"

Browse Popular Code Answers by Language