SQLite - get first weekday of current week

select date('now', 'weekday 0', '-1 days');

for further reference please see http://sqlite.org/lang_datefunc.html