SELECT date_format(DATE(table.date_field),'%Y-%m-%d') FROM Table_Name WHERE DATE(table.date_field) BETWEEN DATE('2022-03-01') AND DATE('2022-03-15');