title: How can I convert a JSON date with timezone to a SQL Server datetime?
body: <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>