EXEC tSQLt.NewTestClass 'AccessionDetailsTest';
GO

EXEC tSQLt.Run 'AccessionDetailsTest'

CREATE PROCEDURE AccessionDetailsTest.[Fetch Records]
AS
BEGIN
    DECLARE @TIMEINTERVAL INT = 24;
    DECLARE @rowCount INT;
    DECLARE @CURRENTTIME datetimeoffset = SYSDATETIMEOFFSET()

    SELECT
        *
    FROM
        Accession
    WHERE
        OrderStatus = 'UC' and SWITCHOFFSET(AccessionDate, DATENAME(TZ, SYSDATETIMEOFFSET())) <= DATEADD(hh, -@TIMEINTERVAL, @CURRENTTIME)
        AND SWITCHOFFSET(AccessionDate, DATENAME(TZ, SYSDATETIMEOFFSET())) <= @CURRENTTIME

    SET @rowCount = @@ROWCOUNT;

    EXEC tSQLt.AssertEquals 25000, @rowCount
END;
GO

EXEC tSQLt.Run 'AccessionDetailsTest'