This documentation is archived and is not being maintained.

MONTH (SSIS Expressions)

Returns an integer that represents the month datepart of a date.


MONTH(date)

date

Is a date in any date format.

MONTH returns a null result if the argument is null.

A date literal must be explicitly cast to one of the date data types. For more information, see Integration Services Data Types.

NoteNote

The expression fails to validate when a date literal is explicitly cast to one of these date data types: DT_DBTIMESTAMPOFFSET and DT_DBTIMESTAMP2.

Using the MONTH function is briefer but equivalent to using DATEPART("Month", date).

This example returns the number of the month in a date literal. If the date is in "mm/dd/yyyy" format, this example returns 11.

MONTH((DT_DBTIMESTAMP)"11/23/2002")

This example returns the integer that represents the month in the ModifiedDate column.

MONTH(ModifiedDate)

This example returns the integer that represents the month of the current date.

MONTH(GETDATE())
Show: