Results 1 to 2 of 2
Thread: DATETIME field, update only day
Apr 4, 2008, 03:16 #1
- Join Date
- Jan 2006
- Manchester, UK
- 0 Post(s)
- 0 Thread(s)
DATETIME field, update only day
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?