First & last days of last month

from the Artful Common Queries page


select 
  date_format(curdate() - interval 1 month,'%y-%m-01') as firstday,
  last_day(curdate() - interval 1 month) as lastday;

Last updated 4 Apr 2020




Return to the Artful Common Queries page