SQL Server function to return interval a date interval between 2 datetime fields

date_interval.sql

IF EXISTS (SELECT *
             FROM dbo.sysobjects
            WHERE id = object_id (N'[dbo].[date_interval]')
              AND OBJECTPROPERTY(id, N'IsTableFunction') = 1)
DROP FUNCTION [dbo].[date_interval]
GO

CREATE FUNCTION [dbo].[date_interval] ( @p_start datetime, @p_end datetime)
RETURNS @DATES TABLE ( generated_date datetime )
AS
BEGIN
    
    DECLARE @minutes_interval INT = datediff(mi,  @p_start, @p_end);
    
    INSERT INTO @DATES
    SELECT @p_start
    UNION ALL
    SELECT 
		DATEADD(MINUTE, g.intvalue, @p_start)
	FROM generate_series(1, @minutes_interval) AS g
    
    RETURN
END
GO