How do I make a query in SQL where the date is greater than a certain date in SQL Server?

I am trying this code:

SELECT *

FROM dbo.March2010 A

WHERE A.Date >= 2010-04-01;

A.Date looks like: 2010-03-04 00:00:00.000

But, this is getting the desired output.

Can anybody address my query? or give any reference for this.

Your Answer