Get day of month : Day « Date Time « SQL / MySQL






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

Get day of month

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

*/  
SELECT DAYOFMONTH(CURRENT_DATE);








Related examples in the same category

1.Use DAYOFMONTH in a where clause
2.Extract the day of the month out of a value: DAY()