Returns the day of the month based on the month field in date_exp as an integer value in the range of 1-31.

 

Example:

SELECT DAYOFMONTH({d '2001-09-13'}) returns 13