/* mysql> SELECT DAYOFMONTH(CURRENT_DATE); +--------------------------+ | DAYOFMONTH(CURRENT_DATE) | +--------------------------+ | 10 | +--------------------------+ 1 row in set (0.00 sec) */ SELECT DAYOFMONTH(CURRENT_DATE);