MySQL yyyy-mm-ddThh:mm:ss.sssZ to yyyy-mm-dd hh:mm:ss
<p>I want to upload my csv file that contains <code>yyyy-mm-ddThh:mm:ss.sssZ</code> data.</p>

<p>When I set <code>DATETIME</code> type in MySQL, </p>

<blockquote>
  <p>I got error code 1292.</p>
</blockquote>

<p>MySQL How can I upload <code>yyyy-mm-ddThh:mm:ss.sssZ</code> type successfully?</p>

<p><a href="https://i.stack.imgur.com/2mLFR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2mLFR.png" alt="enter image description here"></a>   </p>