CURRENT DATE - (DAY(CURRENT DATE)-1) DAYS - 1 MONTH or CURRENT DATE - (DAYOFMONTH(CURRENT DATE)-1) DAYS - 1 MONTH