MSSQL Update Statement : I want to update the TimeOccurred column in all tables in a database (also fine with doing 1 table at a time if that is necessary).  This is what the current values in this column look like:

2017-06-12 14:34:00

I would like to replace that value in all tables in the column TimeOccurred by changing just the year to the current year and the month to the previous month.

So 2012-03-14 14:34:00 becomes 2017-05-14 14:34:00.

It would also help if I could check the day and if it was 29,30,or 31 change it to 25.