mysql获取本周星期几、当天是本月多少号

#本周星期几
select dayofweek(NOW()) -1;
CASE WHEN dayofweek(NOW()) = 1 THEN 7 ELSE dayofweek(NOW()) -1 END

#本月多少号
select DAYOFMONTH(NOW());

plan_start_date = 2020-08-04 12:09:22’’

#转换年
extract(year from plan_start_date) year,

#转换月
extract(month from plan_start_date) month,

#转换天
extract(day from plan_start_date) day,

#转换季度
extract(quarter from plan_start_date) quarter,