title: SQL Server Date Comparison from string to datetime
body: <p>I am using a SQL Server 2016 database and in my stored procedure I want to compare two dates.</p>
  
  <p>I get one date parameter as string in 'dd-MM-yyyy' format.     </p>
  
  <pre><code>@stringdate = '28-12-1990'   // I get date in this format
  </code></pre>
  
  <p>I want to convert this to date format and compare with a database column which is of type <code>datetime</code>. </p>