Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

MONTH(date) returns the month for date, in the range 0 to 12

mysql> mysql> SELECT MONTH('1998-02-03'); +---------------------+ | MONTH('1998-02-03') | +---------------------+ |                   2 | +---------------------+ 1 row in set (0.00 sec) mysql>