title: I can't convert a string to datetime in SQL Server 2017
body: <p>I have the following table:</p>
  
  <pre><code>name    lastchecked article_node
  --------------------------------
  a       18/08/2017  guid
  b       27/09/2017  guid
  c       27/09/2017  guid
  d       10/08/2017  guid
  e       10/08/2017  guid
  f       18/08/2017  guid
  g       18/08/2017  guid
  </code></pre>
  
  <p>And I want to convert the <code>lastchecked</code> column into a date. Currently it's a <code>varchar(150)</code>. I tried using the <code>UPDATE</code> function like so:</p>
  
  <pre><code>update [dbo].[table]
  set [lastchecked] = cast([lastchecked] as date)
  </code></pre>
  
  <p>But I get the following error:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>Does anyone know what the error could possibly be? </p>