DATE_SUB(CURDATE(), INTERVAL 6 month) code example

Example: mysql last 6 months

.... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)