how to get data from 6 to 6 in mysql code example Example: mysql last 6 months .... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)