title: To Get YEARMONTH from date in Athena
body: <p>I can get year and month separately in Athena but i don't know how to get YEARMONTH from date.</p>
  <pre><code>select year(date1) from table1
  select Month(date1) from table1
  </code></pre>
  <p>Please suggest how to get YEARMONTH. Thank you in advance.</p>