SQL - Query condition for future date time

Question

Im having trouble with this query. I want to not select records that have passed the SYSTIME for the current date but display records for future dates even if they have passed the current SYSTIME

SELECT * 
  FROM TABLE
 WHERE DATE>= CONVERT(date, SYSDATETIME())
   AND STARTTIME > CONVERT(time, SYSDATETIME())

This is the query. I know why it doesnt work but I can't think of a way to do what I stated above.

Answer 1

SELECT * 
FROM TABLE
WHERE 
  (
   (DATE = CONVERT(date, SYSDATETIME() 
    AND STARTTIME > CONVERT(time, SYSDATETIME()
   )
    OR Date > sysdatetime()
  )

You need an or condition since date time are in different fields you must first resolve today's date and time and then all future dates regardless of time.