Mega Code Archive

 

Categories / MySQL / Date Time

 

Get month of a date

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