Date Problem

[Eric Scuccimarra]

We have a table with a Date Time field and we need to update only the date 
portion of that field.

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]