Stored procedure that returns time +additional hours.

Question

question

fashraf asked Aug 25, '12

Stored procedure that returns time +additional hours.

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.

stored-procedures time

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-08-25T20:07:43Z

ThomasRushton answered Aug 25, '12

So what you need to do is [CREATE a PROCEDURE][1] that makes use of the [DATEADD][2] function... I'm not going to answer the question fully, because it looks like homework... [1]: http://msdn.microsoft.com/en-us/library/ms187926.aspx [2]: http://msdn.microsoft.com/en-us/library/ms186819.aspx

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

fashraf commented · Aug 26, 2012 at 07:07 AM

Thanks a ton..Sorry to bother you !

0 ·

question