Re: DAYNAME problem using CASE statement

[John Noble]

If I change the code to

set @d = '2020-04-04'; -- sat 
SELECT 
@d, DAYNAME(@d), 
CASE DAYNAME(@d) WHEN "Saturday" THEN DATE_ADD(@d, INTERVAL 2 DAY) 
ELSE DATE_ADD(@d, INTERVAL 1 DAY) END as despatchDate;

Then it works.

Im using 5.5.3.
Maybe thats the difference.

Thanks again,

John