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