How can I query all rows that are currently before data specified in one column in table?

Question

I need to get all rows tha are valid, ValidDate is column that shows how long these database items are valid. I need to get only valid items from the database. How can I do that? I use SQL Server.

Answer 1

Assuming ValidDate means valid until:

SELECT Cols
FROM MyTable
WHERE getdate() <= ValidDate 

Answer 2

Something like this perhaps?

SELECT * FROM table WHERE ValidDate => GETDATE()