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?