Date sort in SQL?

Question

SQL

I am writing WEB.API using EF. Actually there is a DB in which there is a column 'Date' (screen). How to sort so that the date "Today and later" is displayed and dates that have already passed are not displayed?

Answer 1

If it's EF, then maybe justwhere date > DateTime.Now

Answer 2

This is?

DECLARE @curdate date 
SELECT INTO @curdate CAST(CURRENT_TIMESTAMP as date)

SELECT * 
FROM t
WHERE Date >= @curdate