MONTH INTERVAL on mysql

[fantic]

what is the query for 3 month interval(only month should be displayed) in mysql. I want to show like janauary to march or november to january of next year. plz help me.

[fenway]

You mean like + INTERVAL 3 MONTH?

[fantic]

3 months period for ex: if this month is November then October,November and December or if This month is December than November, December and January

[corbin]

SELECT blah FROM table WHERE SomeColumn BETWEEN something AND SomethingElse;

 

 

Depending on the format of your column, you will need to use the corresponding values there.

 

 

Example:

 

 

SELECT * FROM events WHERE event_date (BETWEEN DATE_ADD(NOW(), INTERVAL + 3 MONTHS) AND DATE_ADD(NOW(), INTERVAL + 4 MONTHS));

[fenway]

or BETWEEN event_date - INTERVAL 1 MONTH AND event_date + INTERVAL 1 MONTH

 

But of course you'll need to start for the beginning of the month, so you might want to use extract the YEARMONTH.