Update a datetime field by adding extra time in MySql
January 14th, 2010
No comments
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. Read more…
Recent Comments