Date of 1st day of last, this, next month

from the Artful Common Queries page


Date of first day of previous month:
concat(left(curdate() - interval 1 month, 8), '-01')
Date of first day of this month:
concat(left(curdate(), 8), '-01') 
Date of first day of next month:
concat(left(curdate() + interval 1 month, 8), '-01')

Last updated 29 Mar 2018




Return to the Artful Common Queries page