mohamme...@gmail.com
unread,Mar 22, 2016, 10:49:09 AM3/22/16Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to sqldf
I'm trying to run the following query in R:
result <- sqldf("select t.IncidentYear, count(*) as YearlyIncidentCount
from (select fi.*, year(fi.INCIDENT_DATE) as IncidentYear
from [databse_inci].[dbo].[fire_incident] fi) as t
group by t.IncidentYear")
it gives me the following error:
"sqliteSendQuery(con, statement, bind.data): error in statement: no such function: year "
It is not recognizing inbuilt function year(). How do I solve this ?
-Mohammed