MONTH(<date>)
Returns only the month of a date represented as an integer from 1 to 12.
Column1
MONTH returns
May 2, 2011 3:55:03 PM
5
Aug 31, 2011 11:30:47 AM
8
Apr 12, 1978 12:05:08 PM
4