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, `2009-07-01` would be updated to `2009-06-15`. 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.
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])http://mysql.meetup.com/144/
This message was sent by Michael Rulison ([address removed]) from The Raleigh MySQL Meetup Group.
To learn more about Michael Rulison, visit his/her member profile: http://mysql.meetup.com/144/members/7328344/
To unsubscribe or to update your mailing list settings, click here: http://www.meetup.com/account/comm/
Meetup Support: [address removed]
632 Broadway, New York, NY 10012 USA