Update only Time in a mysql DateTime field July 22, 2023 by Tarik Try this: UPDATE yourtable SET yourcolumn = concat(date(yourcolumn), ' 21:00:00') WHERE Id = yourid;