title: Parsing the date with timezone MySQL
body: <p>In a table say <strong>testTable</strong> we are storing date-time as <code>varchar</code> in following format</p>
  
  <pre><code>Tue May 09 15:16:54 IST 2017
  </code></pre>
  
  <p>I am trying to write a query which gives me all records between two dates using <code>STR_TO_DATE</code> to convert the date in <code>varchar</code> format to <code>datetime</code>. However below query is failing with <code>Error Code: 1241 Operand should contain 1 column(s)</code></p>
  
  <pre><code>SELECT * FROM test12.testTable a WHERE a.timestamp BETWEEN (STR_TO_DATE('Tue May 09 17:26:11 IST 2017', '%a %b %d %H:%i:%s %Z %Y'), 
    STR_TO_DATE('Wed May 10 20:17:11 IST 2017', '%a %b %d %H:%i:%s %Z %Y'));
  </code></pre>
  
  <p>Could you suggest what is wrong here?</p>