How can I convert a JSON date with timezone to a SQL Server datetime?
<p>I saved the output of a JSON object in a CSV file. I want to import the data into SQL Server. I have tried to cast the JSON date column to a SQL Server datetime data type.</p>

<pre><code>select cast('2009-06-18T16:44:20+0000' as datetime)
</code></pre>

<p>This causes an error to be raised: Conversion failed when converting date and/or time from character string. </p>

<p>How can I convert a JSON date with timezone to a SQL Server datetime?</p>