A bit of a challenge here, trying to get the first and last day of the previous week (Sunday and Saturday).
SELECTDate_add(Date_add(Now(), INTERVAL - Weekday(Now())-1 day),INTERVAL -7 day) 'Sunday',Date_add(Date_add(Date_add(Now(), INTERVAL - Weekday(Now())-1 day), INTERVAL 6 day),INTERVAL -7 day) 'Saturday';
Nenhum comentário:
Postar um comentário
Leave your comment here!