title: Mysql string to date with given format containing a timezone specifier
body: <p>I have a string column in my database as</p>
  
  <pre><code>Wed Aug 13 17:51:06 GMT+05:30 2014
  </code></pre>
  
  <p>Can i cast this to date and use this in where clause to get records </p>
  
  <pre><code>where
  Timecolumn &gt;( CURDATE()-7)
  </code></pre>
  
  <p>Notice that the timezone specifier <code>GMT+05:30</code> comes between the time-of-day string and the four digit year string.</p>
  
  <p>I am running this query in phpmyadmin but i get no results and yes they do exist</p>
  
  <pre><code> SELECT * FROM `calldetails` WHERE STR_TO_DATE('date', '%a %b %d %H:%i:%s %x %Y')&gt;(CURDATE()-7)
  </code></pre>
  
  <p>Also date is name of my column here</p>