MS SQL Server :: Update A Datetime Column - BigResource

I'm trying to update a datetime column from another datetime column. However, I just want the date transferred to the new column without the time. Any ideas?

www.bigresource.com