[RESOLVED] (SQL2005) Set query condition as date

Guys i want to set my query condition as current date how do i do that?

say select * from Me where Date > Current date

Code:

---

SELECT * FROM [Me]
WHERE [Date] > GETDATE()

---

returns anything greater than today's date -

Reference:
http://msdn2.microsoft.com/en-us/lib...3(SQL.90).aspx

thanks NPassero i finally figured it out liked this

SELECT * FROM WHERE (B.EstimatedClosedate > (SELECT GETDATE() AS TodayDate))