@ziangij

please try the code below. I think this is what the auhtor wanted to convey. However one thing I would like to point out that Datetime is 8byte and Int is 4byte.

DECLARE @a INT

DECLARE @b-2 DATETIME

set @a= getdate()

SET @b-2 = @a

Thanks,

Tushar