title: Convert mediumtext to date
body: <p>I have column data that stores date in mediumtext datatype. How do I convert mediumtext to date so I can extract data for certain time range.</p>
  
  <p>Thank you</p>
  
  <p>Sample data:</p>
  
  <ul>
  <li>Fri Sep 11 15:30:55 JST 2015</li>
  <li>Fri Sep 11 15:40:09 JST 2015</li>
  <li>Fri Sep 11 14:55:09 SGT 2015</li>
  <li>Fri Sep 11 14:57:38 SGT 2015</li>
  <li>Fri Sep 11 03:59:02 EDT 2015</li>
  <li>Fri Sep 11 01:10:17 PDT 2015</li>
  </ul>