MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.30


CREATE TABLE items (
  id INT,
  dt DATETIME
)
INSERT INTO items VALUES
  (1, ADDTIME(SYSDATE() + INTERVAL -2 DAY, '00:10:00')),
  (2, ADDTIME(SYSDATE() + INTERVAL -2 DAY, '00:20:00')),
  (3, ADDTIME(SYSDATE() + INTERVAL -1 DAY, '00:10:00')),
  (4, ADDTIME(SYSDATE() + INTERVAL -1 DAY, '00:20:00')),
  (5, ADDTIME(SYSDATE(), '00:10:00')),
  (6, ADDTIME(SYSDATE(), '00:20:00'))
;

Records: 6  Duplicates: 0  Warnings: 0


SELECT * FROM items;


id
dt


1
2023-05-12 12:37:05

2
2023-05-12 12:47:05

3
2023-05-13 12:37:05

4
2023-05-13 12:47:05

5
2023-05-14 12:37:05

6
2023-05-14 12:47:05


SELECT
    id,
    dt,
    CASE DATE(dt)
      WHEN CURDATE() THEN 'Сегодня'
      WHEN CURDATE() + INTERVAL -1 DAY THEN 'Вчера'
      ELSE 'Ранее'
    END AS when_day
  FROM items
;


id
dt
when_day


1
2023-05-12 12:37:05
Ранее

2
2023-05-12 12:47:05
Ранее

3
2023-05-13 12:37:05
Вчера

4
2023-05-13 12:47:05
Вчера

5
2023-05-14 12:37:05
Сегодня

6
2023-05-14 12:47:05
Сегодня

id	dt
1	2023-05-12 12:37:05
2	2023-05-12 12:47:05
3	2023-05-13 12:37:05
4	2023-05-13 12:47:05
5	2023-05-14 12:37:05
6	2023-05-14 12:47:05

id	dt	when_day
1	2023-05-12 12:37:05	Ранее
2	2023-05-12 12:47:05	Ранее
3	2023-05-13 12:37:05	Вчера
4	2023-05-13 12:47:05	Вчера
5	2023-05-14 12:37:05	Сегодня
6	2023-05-14 12:47:05	Сегодня