samedi 19 décembre 2015

Data cannot be retrieved by given a specific month

I wanted to retrieve data which month is belong to 12.

 public Cursor readData()
    {
        Cursor c=database.rawQuery(" SELECT _id, Date,Weather,Status, TimeIn_Info, TimeOut_Info FROM " + MyDatabaseHelper.TABLE_INFO +
                        " WHERE  strftime('%m',Date) = ? ",
                new String[]{12+""}, null);
        if (c != null) {
            c.moveToFirst();
        }
        return c;
    }

However, no data get displayed. I have make sure it has a data with a month 12.

MyDatabaseHelper for Table_Info

     public static final String TABLE_INFO="Information";
     public static final String Date="Date";
     public static final String Status="Status";
     public static final String TimeIn_Info="TimeIn_Info";
     public static final String TimeOut_Info="TimeOut_Info";
     public static final String Weather="Weather";
     public static final String Name="Name";

     public void onCreate(SQLiteDatabase db) {
            db.execSQL("create table " + TABLE_INFO + " ( " + ID + " INTEGER PRIMARY KEY ,Name TEXT,Weather TEXT, Date DATETIME, Status Text, TimeIn_Info DATE TIME, TimeOut_Info DATETIME)");
      }

I select the date by using date-time picker and the Date holds the date with the format 19-12-2015.

There are nothing wrong with my database because data get displayed when I change the condition to name.

Can someone helps me to figure out the problem ?

Aucun commentaire:

Enregistrer un commentaire