|
|
|
|
|
|
|
|
|
|
version 11
DAYOFMONTH (arithmetic_expression)
Description
The DAYOFMONTH function returns a number representing the day of the month (ranging from 1 to 31) of the date passed in the arithmetic_expression.
Example
Supposing that we have the PEOPLE table with a Date_of_Birth field. To find out the day number of the date of birth for every person in PEOPLE:
SELECT DAYOFMONTH(Date_of_Birth) FROM PEOPLE;
See Also
DAY, DAYNAME, DAYOFWEEK, DAYOFYEAR.
|
|
|
|
|
|
|
|
|
|