How to display the time interval that I need?

Question

MySQL

I need to display records with an interval of half a year.
I write:

SELECT * FROM `calendar` WHERE MONTH(`date`) BETWEEN MONTH(NOW()) AND (MONTH(NOW()) + 4)

it displays all the data for 5 months, but grabs another record for a month from another year.
Who will tell, otherwise he broke his whole head

Answer 1

something like this:

SELECT * FROM `calendar` WHERE `date` BETWEEN NOW() AND DATE_ADD(NOW(),INTERVAL 6 MONTH);