Mysql DAYOFMONTH
From w3cyberlearnings
Contents |
MySQL DAY Function
This function is a synonym for DAYOFMONTH() function. It returns the day of a month.
Syntax DAY
- expre: date or datetime expression
DAY(expre);
Example 1
mysql> SELECT DAY('2012-05-21'); +-------------------+ | DAY('2012-05-21') | +-------------------+ | 21 | +-------------------+ 1 row in set (0.00 sec)