Hello Everyone,
I have the following code that returns the first and last day of the month
SELECT DATE_SUB(curdate(),INTERVAL (DAY(curdate())-1) DAY);
SELECT LAST_DAY(now() - interval 1 day );
But I need a select statement similar to
SELECT a_field, a_date from a_table
WHERE a_date BETWEEN firstday_of_the_month AND last_day_of_the_month
Can someone help me build the statement correctly? please…
JM.