Create function that can receive arguments of multiple types

Question

I need to create function that will find a lesser of two values. It should receive either INT or TIME type arguments. Something of this structure:

CREATE FUNCTION fn_Min(@p_1 (time or int), @p_2 (time or int))
RETURNS time
AS
BEGIN
    DECLARE @lesser (time or int)
    IF @p_1 <= @p_2
        SET @lesser = @p_1
    ELSE 
        SET @lesser = @p_2
    RETURN @lesser  
END

Is it possible?

wiretext · Accepted Answer · 2015-10-29 08:37:05Z

1

you can use sql_variant

Function

CREATE FUNCTION fn_Min(@p_1 sql_variant, @p_2 sql_variant)
RETURNS sql_variant
AS
BEGIN
    DECLARE @lesser sql_variant
    IF @p_1 <= @p_2
        SET @lesser = @p_1
    ELSE 
        SET @lesser = @p_2
    RETURN @lesser  
END

Call

SELECT dbo.fn_Min(CAST('3:00 AM' AS TIME),CAST('11:00 AM' AS TIME))
SELECT dbo.fn_Min(5,6)

answered Oct 29, 2015 at 8:37

wiretext

3,35216 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create function that can receive arguments of multiple types

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related