Obtaining the Current Year, Month, Day, Hour, Minute, or Second : Month « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. Month

Obtaining the Current Year, Month, Day, Hour, Minute, or Second

    
mysql>
mysql> SELECT CURDATE( ), YEAR(CURDATE( )) AS year,
    -> MONTH(CURDATE( )) AS month, MONTHNAME(CURDATE( )) AS monthname,
    -> DAYOFMONTH(CURDATE( )) AS day, DAYNAME(CURDATE( )) AS dayname;
+------------+------+-------+-----------+------+---------+
| CURDATE( ) | year | month | monthname | day  | dayname |
+------------+------+-------+-----------+------+---------+
| 2011-10-03 | 2011 |    10 | October   |    3 | Monday  |
+------------+------+-------+-----------+------+---------+
1 row in set (0.00 sec)

mysql>
mysql>








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.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