Merging Date and Time Columns to Update a DateTime Field in SQL Server

Data and Databases
1

How do I merge separate date and time columns into one datetime field in SQL Server 2008? I can update each individually, but combining them poses a challenge. Example:

UPDATE MyRecords
SET CombinedTS = CAST(CONVERT(varchar(10), DateCol, 120) + ' ' + CONVERT(varchar(8), TimeCol, 108) AS datetime)
2

hey flyingeagle, hav u tested different format conversions? i once had a similar issu when combining dates. sometimes little format nuances can trip u up. any luck with alternative conversion approaches?