Mega Code Archive

 

Categories / MySQL / Date Time

 

Get day of month

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