SQL Convert yyyy-mm-ddTHH:mm:ss to DateTime
<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>