I have create a database like below:
db.execSQL("CREATE TABLE petrol (" + "_id INTEGER PRIMARY KEY,"
+ "date datetime," + "total INTEGER," + "price FLOAT)");
and I want to get the specified month rows using the command like below:
mSelection = "year(date)=2008 and month(date)=2"
mResolver.query(Provider.CONTENT_URI, null, mSelection, null, null);
but an error appeared wrote:
no such function: month while compiling....
does the database of android supoort the year or month function?