date time column data 1

[myvision69]

i have a date time column from which i only need to get the time portion hh:mm only and combine it with today's date into a datetime column.

e.g. 01/01/2000 12:12:00 needs to be converted to getdate() + time from column = 04/12/2006 12:12:00


Thanks for prompt reply

 

[vongrunt]

select myDatetimeColumn + datediff(dd, myDatetimeColumn , getdate())

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]