查询当前日期，星期几，月份，第几周，是否是工作日

SELECT NOW() ‘日期（date）’, SYSDATE() ‘日期（string）’, CASE
DATE_FORMAT(NOW(),‘%w’)
WHEN 1 THEN ‘一’
WHEN 2 THEN ‘二’
WHEN 3 THEN ‘3’
WHEN 4 THEN ‘4’
WHEN 5 THEN ‘五’
WHEN 6 THEN ‘6’
WHEN 7 THEN ‘日’
END
as ‘星期’,date_format(NOW(), ‘%Y-%m’) ‘月份’,WEEK(NOW()) as ‘第几周’,CASE WHEN DATE_FORMAT(NOW(),‘%w’)>5 THEN ‘是’
ELSE ‘否’
END AS ‘是否工作日’