[RESOLVED] (SQL2005) Set query condition as date

[GARAKWAZVO]

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

say select * from Me where Date > Current date