title: substr at Amazon Athena
body: <p>At Amazon Athena, I want to extract only the character string "2017-07-27" from the character string "2017-07-27 12:10:08".</p>
  
  <pre><code>SELECT SUBSTRING (event_datetime.s, 0, 10) FROM production limit 10
  </code></pre>
  
  <p>I tried it like this which only returns numbers 0 to 10.</p>
  
  <p>At Athena, is it possible to cut character strings? If so, how can I do it?</p>
  
  <p>Or, if you know how to cast "2017-07-27 12:10:08" to date type, that's fine.</p>
  
  <p>Thank you.</p>