Update a datetime field by adding extra time in MySql
If you want to update a datetime field in a mysql table by adding some extra hours for example you can use the next statement:
UPDATE table_name SET column_name = ADDTIME(column_name, '9:0:0')
This will add 9 hours to each row of the table.
This is related to:
- MySql update datetime
- MySql add time to datetime
- Mysql datetime addtime
Recent Comments