DATE_SUB « Date Time « SQL / MySQL

1.Find the date a week ago
2.Calculated dates are useful for range testing
3.Calculate the last day of the month for the previous, current, and following months relative to a given date,
4.Finding First and Last Days of Months
5.Finding the Length of a Month
6.The last day of the previous month is a special case for which the general expression can be simplified quite