quarter

Returns the quarter in "date_expression" as a number in the range 1 to 4, where 1 represents January 1 through March 31.

quarter ( date_expression )

quarter ( 2005-11-01 )