sql filter where date has to be greater than the past code example

Example: query less than datetime sql

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