We have table a with field Foo with value '2004-01-01 12:15:00' and a date '2004-03-01' and we need to change the date portion of Foo to the date and leave the time part alone.
So Foo would change from: '2004-01-01 12:15:00' to: '2004-03-01 12:15:00'
I've been struggling with this for several hours now and I know there must be an easy solution. Any suggestions?
Thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]