title: Presto/SQL - Converting string timestamp to date throws error
body: <p>NOTE: I am running my query in <strong>Qubole's</strong> presto and sql command engine.</p>
  
  <p>I am trying to convert my string timestamp to just date but none of the options are working out.</p>
  
  <p>My string timestamp looks like <code>2017-03-29 10:32:28.0</code>
  and I want to have it like <code>2017-03-29</code></p>
  
  <p>I have tried following queries to convert this <em>string</em> timestamp to retrieve date</p>
  
  <pre><code>1. select cast(created as date) from table1
  </code></pre>
  
  <blockquote>
    <p>Value cannot be cast to date: 2017-05-26 17:23:58.0</p>
  </blockquote>
  
  <pre><code>2. select cast(from_iso8601_timestamp(created) as date) from table1
  </code></pre>
  
  <blockquote>
    <p>Invalid format: "2014-12-19 06:06:36.0" is malformed at " 06:06:36.0"</p>
  </blockquote>
  
  <pre><code>3. select date(created) from table1
  </code></pre>
  
  <blockquote>
    <p>Value cannot be cast to date: 2012-10-24 13:50:00.0</p>
  </blockquote>
  
  <p>How I can convert this timestamp to date in presto/sql? </p>