title: How to convert a nvarchar(255) to YYYY-MM-DD format?
body: <p>I need help in writing a SQL statement to convert date column which is of type <code>nvarchar(255)</code> into a date type 'yyyy-mm-dd' format</p>
  <p>I tried all the alternatives available across stackoverflow relating this topic but couldn't find a solution for my dataset.</p>
  <p>The sample data:</p>
  <pre><code>Fri, 23 Oct, 2020
  Mon, 19 Oct, 2020
  Fri, 16 Oct, 2020
  Tue, 20 Oct, 2020
  Tue, 27 Oct, 2020
  </code></pre>
  <p>To date format:</p>
  <pre><code>2020-Oct-23
  2020-Oct-19
  2020-Oct-16
  2020-Oct-20
  2020-Oct-27
  </code></pre>
  <p>I am using SQL server 2014.</p>