I have mysql query that gets and display data that are within the current month.
This is the condition that I used
WHERE month(date) = MONTH(NOW())
But it doesn't seem to work because currently it is June 1 in my country but the code is getting data that are from May. What is the problem with this?