title: AWS Athena date_Part
body: <p>I'm trying to truncate the date to just the day using Athena. 
  Here's what the input and select statement look like:</p>
  
  <pre><code>create table ...
  usagestartdate timestamp,
  usageneddate timestamp,
   ...
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
  WITH SERDEPROPERTIES (
  'serialization.format' = ',',
  'field.delim' = ',',
  "timestamp.formats" = "yyyy-MM-dd'T'HH:mm:ss.SSSSS'Z'") 
  LOCATION 's3:
  
  then to get just the day
  
  select...
  resource string
  day(usagestartdate)
  sum(usagehours)
  </code></pre>