How long in days is a MONTH in MySQL?
If one finds where the past number of months equals the past number of days like this,
select distinct DATE_SUB(now(), INTERVAL 92 DAY),DATE_SUB(now(), INTERVAL 3 MONTH)
The numbers that are currently returned are,
- 1 month = 31 days
- 2 month = 62 days
- 3 month = 92 days
- 4 month = 123 days
- 5 month = 153 days
- 6 month = 184 days
Is MySQL rounding the number of days or is it taking into account the number of days in a particular month?