select mdy(month(today-day(today) units day),1,year(today-day(today) units day)) from 表名 (獲取上月第一天)
//2021-11-01
select mdy(11,1,2021) from 表名
//2021-11-01
select today-1 units month from 表名 (獲取上月本月的同一天,續慎用,如果出現本月31號,上月只有30號,會報錯)
//2021-11-01
select today-day(today)+1 units day from 表名 (獲取本月第一天)
//2021-12-01
select last_day(today) from 表名 (獲取本月最後一天)
//2021-12-31
注:units後面接單位