Extract the day of the month out of a value: DAY() : Day « Date Time « SQL / MySQL

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

Extract the day of the month out of a value: DAY()

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

   
    
    
  

Related examples in the same category