MONTH

Syntax

MONTH(<date>)

Description

Returns only the month of a date represented as an integer from 1 to 12.

Examples

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