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

 

Example:

SELECT MONTH({d '2000-09-13'}) returns 9