... example has to work with any given date.
First of all: Get this week's dates and days:
SELECT
DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS ThisDate,
DAYNAME( DATE_ADD( NOW( ...
... up DyNa as matching DNYA.
-- values it did NOT pick up were words like "dayname" and "dynamite".
Additional Notes
Our database and environment need to be in British English, the collation used ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.