目次 |
---|
・先月末を求める |
mysql> SELECT LAST_DAY( DATE( DATE_SUB( NOW( ) , INTERVAL 1 MONTH ) ) ); +-----------------------------------------------------------+ | LAST_DAY( DATE( DATE_SUB( NOW( ) , INTERVAL 1 MONTH ) ) ) | +-----------------------------------------------------------+ | 2012-08-31 | +-----------------------------------------------------------+