Hello Eric, Tuesday, March 9, 2004, 11:46:23 PM, you wrote:
ES> We have a table with a Date Time field and we need to update only the date ES> portion of that field. ES> We have table a with field Foo with value '2004-01-01 12:15:00' and a date ES> '2004-03-01' and we need to change the date portion of Foo to the date and ES> leave the time part alone. ES> So Foo would change from: ES> '2004-01-01 12:15:00' ES> to: ES> '2004-03-01 12:15:00' I would have thought that: UPDATE x SET y = DATE_ADD(y, INTERVAL 2 DAY) would work and not alter the time, but only a test will tell. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
