sql - Update only Time in a mysql DateTime field

Question

How can I update only the time in an already existing DateTime field in MySQL? I want the date to stay the same.

question from:https://stackoverflow.com/questions/1326548/update-only-time-in-a-mysql-datetime-field

Answer 1

Try this:

UPDATE yourtable 
SET yourcolumn = concat(date(yourcolumn), ' 21:00:00')
WHERE Id = yourid;