title: Cast/Convert nvarchar to datetime
body: <p>i have table:</p>
  <pre><code>id   timestamp
  1    31.10.2020 16:32:11
  2    09.09.2020 09:15:49
  3    22.04.2020 02:48:15
  </code></pre>
  <p>Table have huge amount these data. Column timestamp is data type &quot;nvarchar&quot;. And i need to sort datas by date or use in clauses WHERE for constraint by date, so i need to convert &quot;timestamp&quot; to datetime. But I can't. I tried convert and cast but still failed.</p>
  <p>Any advice?</p>
  <p>Thx.</p>