title: SQL Convert yyyy-mm-ddTHH:mm:ss to DateTime
body: <p>How can I convert</p>
  
  <pre><code>2016-01-20T14:27:36.270239Z
  </code></pre>
  
  <p>To a SQL DateTime?</p>
  
  <p>I have tried </p>
  
  <pre><code>CAST('2016-01-20T14:27:36.270239Z' AS datetime)
  </code></pre>
  
  <p>But receive a conversion error.</p>
  
  <p>Cheers</p>