Extract only the month by using the MONTH() function: MONTH() : Month « Date Time « SQL / MySQL






Extract only the month by using the MONTH() function: MONTH()

    
mysql>
mysql>
mysql> SELECT MONTH('2004-12-31 23:59:59');
+------------------------------+
| MONTH('2004-12-31 23:59:59') |
+------------------------------+
|                           12 |
+------------------------------+
1 row in set (0.00 sec)

   
    
    
    
  








Related examples in the same category

1.Have birthdays next month
2.Birthdays in the upcoming month
3.Get month of a date
4.Use MONTH to get the month of a date
5.Use MONTHNAME in where clause
6.Use MONTH to get the month of a date 2
7.Obtaining the Current Year, Month, Day, Hour, Minute, or Second
8.To ensure that the month has two digits-as required for ISO format-use LPAD( ) to add a leading zero as necess
9.Sort by month, then by day within month