Android : SQL lite select for actual week (from monday till sunday)

on Monday, September 8, 2014


I'm trying to select values for actual week from monday to sunday in SQLlite.


I'm trying to do by this way:



SELECT * FROM planned_calls WHERE DATE(date) >= DATE('now', 'weekday 0', '-7 days');


But it return also result from past (for example today is monday but in returned result are results from last sunday too).


How can I do it right please?


Thanks for any advice.


0 comments:

Post a Comment