DATETIME field, update only day

[Dashman]

Hi all,

I have a datetime field in my DB that I am needing to update every morning to the current day. This is purely for some testing I am working on.

I am needing to keep all the times the same, and only update the day portion of the datetime field to the current day.

Is there a simple query I can run to do this?

D

[wysiwyg]

Something like:
UPDATE table SET datecol = DATE_ADD( datecol, INTERVAL 1 DAY );