Share via


MONTH (Transact-SQL)

Returns an integer that represents the month part of a specified date.

Topic link iconTransact-SQL Syntax Conventions

Syntax

MONTH ( date )

Arguments

  • date
    Is an expression that returns a datetime or smalldatetime value, or a character string in a date format. Use the datetime data type only for dates after January 1, 1753.

Return Types

int

Remarks

MONTH is equivalent to DATEPART(mm,date).

Always enclose datetime values in quotation marks. For earlier dates, store dates as character data.

The Microsoft SQL Server 2005 Database Engine recognizes a variety of date styles. For more information about date and time data, see CAST and CONVERT (Transact-SQL).

Examples

The following example returns the number of the month from the date 03/12/1998.

SELECT "Month Number" = MONTH('03/12/1998')
GO

Here is the result set.

Month Number 
------------ 
3            

The following example specifies the date as a number. The Database Engine interprets 0 as January 1, 1900.

SELECT MONTH(0), DAY(0), YEAR(0)

Here is the result set.

----- ------ ------
1     1      1900

See Also

Reference

Data Types (Transact-SQL)
Date and Time Functions (Transact-SQL)
Date and Time (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance