SQL Server Date Time update

I have a column that stored a datestamp.  Goes in with the date and midnight.

07/20/2007 12:00:00 AM

I have another column that a user can "set" a time of HH:MM


I would like to update the date midnight with the date and hh:mm data
Who is Participating?
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Update urTable
SET urDateColumn = CONVERT(Varchar,urDateColumn,112)+' '+@time
All Courses

From novice to tech pro — start learning today.