title: How can I update just the date part of a timestamp?
body: <p>I wish to update just the date part of the timestamp, I don't want to change the time part, I want to do this with mysql but don't know the function or right query to use. Please help, I am a newbie to mysql.</p>