Date interval (+ time) in MySQL?

Question

MySQL

Dear time of day!
To select records in the interval of certain dates, namely yesterday and today, I use the trace. request:

SELECT * FROM matches WHERE (`match_date` >= CURDATE() - INTERVAL 1 DAY) AND (`match_date` < CURDATE() + INTERVAL 1 DAY)

But the problem is that we don't need a full yesterday, namely the last 3 hours (21:00 to 24:00)
How can this be implemented?
Thanks in advance!

Answer 1

If `match_date` contains the time, then

`match_date` >= CURDATE() - INTERVAL 1 DAY + INTERVAL 21 HOUR