title: Comparing dates with current date in Sql server
body: <p>I have a table which has list of some events with dates. I am trying to write a stored procedure that will return only the upcoming events.</p>
  
  <p>I have written the following query in the stored procedure:</p>
  
  <pre><code>SELECT     *
  FROM       Events
  WHERE      tDate &gt;= (select CAST(GETDATE() as DATE))
  </code></pre>
  
  <p>But this is not returning correct result. This is also showing results that have dates less than current date. How to write a query that will return all the events that have date equal or greater than today's date.</p>
  
  <p>Edit: Dates that have been entered on the table have the format yyyy/dd/mm and getdate() returns date in the format yyyy/mm/dd. I think this is causing the problem. Dates that have been entered into the table has been taken using jquery date picker. Any solution to this problem?</p>