title: STR_TO_DATE with timezone
body: <p>I my MySQL (version 5.7.25) database there's have a column, which is full of <code>varchar(100)</code> dates like <code>Fri May 04 08:08:42 UTC 2018</code>. I need to convert them to date.</p>
  
  <p>So far I've came up with</p>
  
  <pre><code>SELECT STR_TO_DATE('Fri May 04 08:08:42 UTC 2018', '%a %b %d %T %Y') AS to_date
  </code></pre>
  
  <p>but it returns null because of the timezone. But if I try:</p>
  
  <pre><code>SELECT STR_TO_DATE('Fri May 04 08:08:42 2018', '%a %b %d %T %Y') AS to_date
  </code></pre>
  
  <p>... it works perfectly. So is there a way to add a timezone to the date format?</p>