mysql-查询日期属于月份第几周

SELECT CONCAT( YEAR(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY) ) , LPAD(MONTH(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY)

发布于 2024-08-21