Change your script to this
declare @date varchar(10)
declare @d datetime
declare @hour varchar(2)
declare @minute varchar(2)
declare @final varchar(20)
set @date='10/14/2014'
set @hour='16'
set @minute='03'
set @final=(@date+' '+@hour+':'+@minute+':00')
set @d =CONVERT(DATETIME, @final)
print @final
print @d
My only question is why are you doing date manipulation with
VARCHAR
?