Database

CREATE FUNCTION [Lib].[IntToTime] (@Subject INT)  
RETURNS DATETIME AS  
BEGIN 
DECLARE @result AS DATETIME
SET @result = '1970-01-01 00:00:00'
 
SET @result = DATEADD ( HH , @Subject/10000 , @result )
SET @Subject = @Subject - @Subject/10000*10000
 
SET @result = DATEADD ( mi , @Subject/100 , @result )
SET @Subject = @Subject - @Subject/100*100
 
SET @result = DATEADD ( ss , @Subject , @result )
 
RETURN ( @result )
END

Sonia Gupta wrote:

now the question is how i can get the values like userid , name , state in the stored procedure while callig these , in stored procs