Why doesn't the select work?

Question

MySQL

I want to select:
All events for the current month, what's wrong?

SELECT * FROM `event` WHERE MONTH(ends_at) = MONTH(CURRENT_TIMESTAMP)

All events for the current week

SELECT * FROM `event` WHERE ends_at <= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY AND ends_at > curdate() - INTERVAL DAYOFWEEK(curdate()) - 1 DAY

All events for today

SELECT * FROM `event` WHERE DATE(ends_at) >= CURDATE()

Where is the mistake?

Answer 1

I forgot that this is a timestamp, and therefore:YEARWEEK(FROM_UNIXTIME(starts_at))

Answer 2

Is it possible to see at least a couple of lines from the 'event' table?
In theory, everything is correct if the ends_at field is of type date or datetime