CODE EXAMPLE FOR SQL

mysql date comparison with formatting

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');