SQL Server MONTH Function


By:

The MONTH function returns the month part of the date as an integer from the date or datetime provided.

Syntax

MONTH(date)

Parameters

  • Date Is the date or datetime provided

Simple MONTH Example

The following example will show the month of March 9, 2021.

SELECT MONTH('3-9-2021 5:00:55 PM') as MONTH
MONTH function example

MONTH function with NULL values

If the parameter of the MONTH function is NULL, a NULL value will be returned.

SELECT MONTH(NULL) as MONTH
month function with null values

Conversion failed error for the MONTH function

A typical error will occur if the date is invalid. The following example is using a wrong month number (13).

SELECT MONTH('13-02-2021 5:00:55 PM') as MONTH

The error message displayed is as follows:

Conversion failed when converting date and/or time from character string.

Using Time with MONTH function

If the MONTH function receives a time parameter, the value returned is 1.

SELECT MONTH('5:00:55 PM') as MONTH
month function with time values

MONTH function with Table Data

The following example will show the month of the StartDate.

SELECT StartDate, MONTH(StartDate) as MONTH
FROM [Production].[ProductCostHistory]
month function in a table

Related Articles


Last Update: 1/4/2022




Comments For This Article





download














get free sql tips
agree to terms