CREATE FUNCTION [dbo].[Time](@Hour int, @Minute int, @Second int)
    returns datetime
as
begin
    return dateadd(hour, @Hour, 0) + dateadd(minute, @Minute,0) + dateAdd(second, @Second,0)
end
go