mysql update all record removing 2 hours from column

Solutions on MaxInterview for mysql update all record removing 2 hours from column by the best coders in the world

showing results for - "mysql update all record removing 2 hours from column"

1UPDATE datetimes
2SET datetime = DATE_ADD(datetime,
3                        INTERVAL (15 - HOUR(datetime)) HOUR);
4

similar questions

how to delete all the rows in a table without deleting the table in mysql mysql delete last row delete double on sql with multiple primary keys mysql trigger to delete old data forcefully delete a row in mysql which has references mysql delete older duplicates mysql delete entire row on condition update multiple columns in mysql mysql delete duplicate rows except one mysql delete duplicate rows remove all records from table mysql how to delete multiple rows in sql delete all content in table mysql mysql update two tables at once mysql delete duplicate rows but keep one update all rows mysql mysql updating multiple column values from array variable mysql auto increment after delete mysql update even 2f odd rows mysql drop multiple tables at once delete all rows from table mysql mysql date minus 1 day update query with between in mysql how to delete all duplicate items in mysql

queries leading to this page

trigger to delete records from table in mysql after 2 days mysql update all record removing 2 hours from column