date greater than equal and less than equal to to in sql code example

Example 1: query less than datetime sql

select *  
from dbo.March2010 A 
where A.Date >= '2010-04-01'

Example 2: date less than in sql

SELECT * FROM wp_osd_properties WHERE `listing_expiration` < '2020-08-05'