mySQL Update Date

[woribhabor]

i want to update the time portion of a date column without knowing or change
the actually day.

so if the list of dates were

xDate
2006-01-12 21:00
2006-01-13 18:00
2006-01-14 16:00
2006-01-15 10:00
2006-01-16 19:00

I want a query that can change all the times 16:00

I am attempting something like

update TABLE_NAME
set xDate = date(date_format(xDate, '%y-%c-%d') & '21:00')

that would keep the same day for every record but update the time to 21:00

[Dan Bracuk]

I don't know mySQL syntax, but your suggested query looks like it wants a where clause of some sort.

[woribhabor]

the where clause in inconsequential.