Returns the quarter in date_exp as an integer value in the range of 1-4, where 1 represents January 1 through March 31.

 

Example:

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