title: SQL - Query condition for future date time
body: <p>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 </p>
  
  <pre><code>SELECT * 
    FROM TABLE
   WHERE DATE&gt;= CONVERT(date, SYSDATETIME())
     AND STARTTIME &gt; CONVERT(time, SYSDATETIME())
  </code></pre>
  
  <p>This is the query. I know why it doesnt work but I can't think of a way to do what I stated above.</p>