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