title: Changing column data from string to datetime data format in sql
body: <p>Any advice on how to change a date time value in a large table with many rows.</p>
  <p>the current datatype is in string format and looks like this in the rows:</p>
  <pre class="lang-none prettyprint-override"><code>23/03/2022 00:00:00
  23/03/2022 00:00:00
  23/03/2022 00:00:00
  23/03/2022 00:00:00
  23/03/2022 00:00:00
  23/03/2022 00:00:00
  </code></pre>
  <p>I have tried convert</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT CONVERT(DATETIME2(7),[start_date] )
     FROM 'table_name'
  </code></pre>
  <p>would like to change this to a datetime format, any advice is much appreciated</p>