Android SQLite is it today

Question

This my Table codes

CREATE TABLE  InformationTable"
            + "(ID INTEGER, "
            + " ConfirmDate TEXT , "
            +" Counter INTEGER DEFAULT 99999"
            +" )";

I want to a select query about InformationTable. I want to create query like this ;

Select * from InformationTable where datetime(ConfirmDate) IS IT TODAY()

How can i do it ?

Possible duplicate of [SQLite Query For Dates Equals Today](http://stackoverflow.com/questions/14709661/sqlite-query-for-dates-equals-today) — Carl Poole, Mar 13 '17 at 17:28

score 1 · Accepted Answer · answered Mar 13 '17 at 17:42

1

If your date is stored as TEXT ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS"), to select the rows for today:

select * from InformationTable where date(ConfirmDate) == date('now');

answered Mar 13 '17 at 17:42

Diego Torres Milano

65,697
9
111
134

Android SQLite is it today

1 Answers1