SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE sortme
             (id integer
                 IDENTITY (1, 1),
              PRIMARY KEY(id));
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
INSERT INTO sortme 
            DEFAULT VALUES;
16 rows affected

DECLARE @today datetime = '2021-01-01 01:01:01';

SELECT *
       FROM sortme
       ORDER BY rand(id * 100000000
                     + 
                     convert(integer,
                             convert(varchar(8),
                                     @today,
                                     112)));


id


16

6

13

3

10

7

14

4

11

1

8

15

5

12

2

9


DECLARE @today datetime = '2021-01-02 01:01:01';

SELECT *
       FROM sortme
       ORDER BY rand(id * 100000000
                     + 
                     convert(integer,
                             convert(varchar(8),
                                     @today,
                                     112)));


id


16

6

13

3

10

7

14

4

11

1

8

15

5

12

2

9


DECLARE @today datetime = '2021-01-03 01:01:01';

SELECT *
       FROM sortme
       ORDER BY rand(id * 100000000
                     + 
                     convert(integer,
                             convert(varchar(8),
                                     @today,
                                     112)));


id


16

6

13

3

10

7

14

4

11

1

8

15

5

12

2

9


DECLARE @today datetime = '2021-01-04 01:01:01';

SELECT *
       FROM sortme
       ORDER BY rand(id * 100000000
                     + 
                     convert(integer,
                             convert(varchar(8),
                                     @today,
                                     112)));


id


16

6

13

3

10

7

14

4

11

1

8

15

5

12

2

9


DECLARE @today datetime = '2021-01-05 01:01:01';

SELECT *
       FROM sortme
       ORDER BY rand(id * 100000000
                     + 
                     convert(integer,
                             convert(varchar(8),
                                     @today,
                                     112)));


id


16

6

13

3

10

7

14

4

11

1

8

15

5

12

2

9