title: How can I extract the month using sqldf package
body: <p>I tried to get a view that is based on group by of date by using sqldf package and a month function but I got an error :<code>Error in sqliteSendQuery(con, statement, bind.data) :   error in statement: no such function: month</code></p>
  
  <p>Here is my query: <code>s&lt;-sqldf("select month(dateTime),sum(wolfs) group by dateTime")</code></p>
  
  <p>Attached is a toy data frame:</p>
  
  <pre><code> df &lt;- read.table(text = "dateTime         birds    wolfs     snakes
                           2014-05-21        9         7    a
                           2014-04-28        8         4    b
                           2014-04-13        2         8    c
                           2014-03-12        2         3    a
                           2014-02-04        8         3    a
                           2014-02-29        1         2    a
                           2014-01-17        7         1    b
                           2014-01-16        1         5    c
                           2014-09-20        9         7    c
                           2014-08-21        8         7    c ",header = TRUE)
  </code></pre>
  
  <p>How can I extract the month using sqldf package?         </p>