SELECT * FROM assignments where stanume= 2 and DATE_FORMAT(assdate,'%Y-%m-%d') <= '2024-05-11'<br>