Stored procedure that returns time +additional hours.

0

I want to create a stored procedure that gives me time + the number of hours i am adding or subtracting..For eg:The stored Procedure gives me current time as 12-8-2012 9:00 am and i will pass +2 ...so the stored procedure will give me 12-8-2012 11:00 am.