Get month of a date : Month « Date Time « SQL / MySQL






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)

*/
           
         
    
  








Related examples in the same category

1.Have birthdays next month
2.Birthdays in the upcoming month
3.Use MONTH to get the month of a date
4.Use MONTHNAME in where clause
5.Use MONTH to get the month of a date 2
6.Obtaining the Current Year, Month, Day, Hour, Minute, or Second
7.Extract only the month by using the MONTH() function: MONTH()
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