title: Conversion failed when converting date and/or time from character string
body: <p>I have this SQL Server query which is returning <code>Conversion failed when converting date and/or time from character string.</code></p>
  
  <pre><code>(
      @numberRecords int,
      @date varchar(12)
  )
  
  AS
  SET ROWCOUNT @numberRecords
  SELECT re.ID, re.RecentChangeTypeID, re.LogID, re.RevisionID
  FROM RecentChanges re
      FULL OUTER JOIN Revisions rev
          ON re.RevisionID = rev.ID
      FULL OUTER JOIN Logs lg
          ON re.LogID = lg.ID
  WHERE convert(datetime, rev.Timestamp) &gt;= '@date' OR
        convert(datetime, lg.Timestamp) &gt;= '@date';
  RETURN
  </code></pre>
  
  <p>The <code>date</code> parameter returns a string value in the format "dd-MM-yyyy". What may be the cause?</p>