Re: Date Manipulation

[Peter Brawley]

You'd need to extract year and month portions, then write logic to handle end-of-year issues, but that'd be a waste of time. Simpler to form a date, eg yyyy-mm-01, and take the left 7 chars of the result of thatdate - interval 1 month, directly or with date_sub().