CURDATE() not working for next month

[honkmaster]

Hi I have a query that returns the count of entries based on CURDATE(), it works for any dat in this month (April) but does not work for next month (May). I think it is something to do with CURDATE()+3 returns 2018-04-31 which should be 2018-05-01

This Works as Date is in April

SELECT COUNT(Machine) FROM production WHERE Status = 'Confirmed'
AND DATE(FROM_UNIXTIME(production.Required)) = CURDATE()

This does not work as in May

SELECT COUNT(Machine) FROM production WHERE Status = 'Confirmed'
AND DATE(FROM_UNIXTIME(production.Required)) = CURDATE()+3

[dsonesuk]

Try with

CURDATE() + INTERVAL 3 DAY

OR

DATE_ADD(CURDATE(),INTERVAL 3 DAY)

 

Edited April 28, 2018 by dsonesuk

[Sherin]

DATE_ADD(CURDATE(),INTERVAL 1 MONTH)

OR

CURDATE()+INTERVAL 1 MONTH

 

Edited January 29, 2020 by Sherin