How to select last 6 months from news table using MySQL March 11, 2023 by Tarik Use DATE_SUB .... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)