Need find the number of days by taking date differnce in sqlite android

Question

I need to get the no of days by taking the date difference of one date confirmation date hard coded value and other with current date in sqlite.

[Refer this][1] [1]: http://stackoverflow.com/questions/289680/difference-between-2-dates-in-sqlite — Sandy, Aug 19 '11 at 07:34

score 1 · Accepted Answer · answered Aug 19 '11 at 07:51

1

SELECT (julianday(Date('now')) - julianday(ConfirmationDate)) FROM [TABLE]

answered Aug 19 '11 at 07:51

Tejo

1 Answers1