Found such a construction
`WHERE WEEK (order_createdAt) = WEEK( current_date)-1 AND YEAR( order_createdAt) = YEAR( current_date );` How to remake a request to take data from last Monday, not Sunday.
cruim cruim
465 3 18
|
1 answer
Last monday is
CURRENT_DATE - INTERVAL (7 + (5 + DAYOFWEEK(CURRENT_DATE)) % 7) DAY Accordingly for sunday
CURRENT_DATE - INTERVAL (1 + (5 + DAYOFWEEK(CURRENT_DATE)) % 7) DAY Well, or instead of CURRENT_DATE, substitute the required date ...
Akina Akina
15.1k one ten 29
- fixed on
AND order_createdAt < CURRENT_DATE - INTERVAL (0 + (5 + DAYOFWEEK(CURRENT_DATE)) % 7) DAYthat last Saturday, the sample ended - cruim - Question, this query will work correctly on any day of the week? - cruim
- Well, if you can not understand the logic - just check. - Akina
|