Hi,

Its not working

i tried with the date as 20101020 and time as 0030.. below is the code

declare @i int,@T smallint

select @i = 20101020

Select @T=0030

select dateadd(minute,@T%100,(dateadd(hour,@T/100,

CONVERT (datetime,convert(char(8),@i))

)))

However i am getting the result as 2010-10-20 00:30:00.000