使用SQL Server实现随机时间分布

CREATE PROCEDURE GenerateRandomTimeData
    @numRows INT
AS
BEGIN
    DECLARE @i INT = 1
    
    WHILE @i <= @numRows
    BEGIN
        -- 生成一个随机小时数，范围在0到23之间
        DECLARE @hour INT = RAND() * 23
        
        -- 生成一个随机分钟数，范围在0到59之间
        DECLARE @minute INT = RAND() * 59
        
        -- 生成一个随机秒数，范围在0到59之间
        DECLARE @second INT = RAND() * 59
        
        -- 构建时间字符串，并插入到表中
        INSERT INTO RandomTimeData (RandomTime)
        VALUES (CONVERT(TIME, DATEADD(HOUR, @hour, DATEADD(MINUTE, @minute, DATEADD(SECOND, @second, 0)))))
        
        SET @i = @i + 1
    END
END

EXEC GenerateRandomTimeData @numRows = 100

-- 查询早上8点到10点之间的随机时间数据
SELECT *
FROM RandomTimeData
WHERE RandomTime >= '08:00:00' AND RandomTime <= '10:00:00'