WEEK_IN_MONTH
Returns a number representing the week in the month for "date_expression". The first week is from the first through the seventh day of the month
Syntax
WEEK_IN_MONTH ( date_expression )Example
WEEK_IN_MONTH ( '2012-02-29' )Result
5