displaying data between date ranges mysql

Posted by Kyle Hudson on Stack Overflow See other posts from Stack Overflow or by Kyle Hudson
Published on 2010-06-07T10:26:48Z Indexed on 2010/06/07 10:32 UTC
Read the original article Hit count: 307

Filed under:
|

Hi Guys,

I need to work out a period of 6 months (backwards) from a given date.

Example date:

07/06/2010 00:00:00

needs to count back 6 months and display:

07/12/2009 00:00:00

I have been scanning through: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html and non of these functions make sense to me :(

Hope this makes sense and any help would be appriciated.

Kyle

© Stack Overflow or respective owner

Related posts about mysql

Related posts about daterange