title: Convert string to timestamp in Impala
body: <p>How can I convert a <code>string</code> representing a datetime in the format <code>"YYYY-MM-DD;HH:MM:SS"</code> (i.e. <code>2016-04-11;19:38:01</code>) to a proper <code>timestamp</code>?</p>
  
  <p>I thought this would work, but it doesn't.</p>
  
  <pre><code>select 
    from_unixtime(unix_timestamp(`date`, "YYYY-MM-DD;HH:MM:SS"))
  from t1
  limit 100;
  </code></pre>