I have problem that is large for me but I hope it is small for you.
MySQL table with unix date field
Goal: reset date from yyyy-mm-01 to yyyy-prior-mm-15
Thus, `[masked]` would be updated to `[masked]`. Actually, I would
like any July date to be set to June-15.
Along the way I want to select for some other attributes and all dates
for 2009 from July through December but those selections I have coped
I have been futzing around with DATE(date-field, INTERVAL -15 DAY)
and some others like DATE_SUB( ), but I keep getting the syntax wrong.
Many thanks for any help.