title: how to count a column by month if the date column has time stamp?
body: <p>I have two columns in a table: </p>
  
  <pre><code>id    date
  1     1/1/18 12:55:00 AM
  2     1/2/18 01:34:00 AM
  3     1/3/18 02:45:00 AM
  </code></pre>
  
  <p>How do I count the number of IDs per month if the time is appended into the date column? </p>
  
  <p>The output would be: </p>
  
  <pre><code>Count   month 
  3        1 
  </code></pre>