YOUR AD GOES HERE

MySQL||How to write CASE EXPRESSION to find Today is WEEKEND or WEEKDAY?

Published 09, Aug 2023

SQLtoSSIStoPowerBI


Description:
SELECT Curdate() AS Todate,Dayname(Curdate()) AS Dayname_Today, CASE Dayname(Curdate())
WHEN 'SUNDAY' THEN 'WEEKEND'
WHEN 'SATURDAY' THEN 'WEEKEND'
ELSE 'WEEKDAY'
END AS Day_Status;

Releted More Videos

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE