P3pJBTx4

1public static final String COLUMN_TS_MILIS = "ts_milis";
2
3public void onCreate(SQLiteDatabase db) {
4String query = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "(" +
5        COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
6        COLUMN_PRODUCT + " TEXT, " +
7        COLUMN_PRICE + " TEXT, " +
8        COLUMN_TS + " TIMESTAMP DEFAULT CURRENT_TIMESTAMP," +
9        COLUMN_TS_MILIS + "timestamp integer default (cast(strftime('%s', 'now') as int))" +
10        ");";
11db.execSQL(query); 
12     
13Cursor totalCof = db.rawQuery("SELECT sum(" + COLUMN_PRICE + ")" + " FROM " + TABLE_NAME
14                    + " WHERE "  + COLUMN_TS_MILIS + "= date('now')", null);