Jump to: navigation, search

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)


Related Links



Navigation
Web
SQL
MISC
References