强制将5分钟间隔设置为datetime SQL Server 2012

SELECT DATEADD(MINUTE, 5, GETDATE()) AS NextDateTime;

DECLARE @CurrentDateTime DATETIME;
SET @CurrentDateTime = GETDATE();

DECLARE @MinutesToAdd INT;
SET @MinutesToAdd = 5 - (DATEPART(MINUTE, @CurrentDateTime) % 5);

SELECT DATEADD(MINUTE, @MinutesToAdd, @CurrentDateTime) AS NextDateTime;

DECLARE @CurrentDateTime DATETIME;
SET @CurrentDateTime = GETDATE();

DECLARE @MinutesToAdd INT;
SET @MinutesToAdd = 
    CASE 
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 5 THEN 5 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 10 THEN 10 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 15 THEN 15 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 20 THEN 20 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 25 THEN 25 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 30 THEN 30 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 35 THEN 35 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 40 THEN 40 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 45 THEN 45 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 50 THEN 50 - DATEPART(MINUTE, @CurrentDateTime)
        WHEN DATEPART(MINUTE, @CurrentDateTime) < 55 THEN 55 - DATEPART(MINUTE, @CurrentDateTime)
        ELSE 60 - DATEPART(MINUTE, @CurrentDateTime)
    END;

SELECT DATEADD(MINUTE, @MinutesToAdd, @CurrentDateTime) AS NextDateTime;