SQL MONTH() Function

SQL MONTH() Syntax

The below syntax is used to get month value from a given input date value using MONTH() function.

For SQL SERVER / MY SQL / MS ACCESS

SELECT MONTH('valid_date_value');

The below syntax is used to read month portion (a integer number from 1 to 12) value from a given table column using MONTH() function.

For MS ACCESS / SQL SERVER / MY SQL

SELECT MONTH(date_column_name1) FROM table_name;

SQL MONTH() Example - Using Expression Or Formula

The following SQL SELECT statement will extract the month value from a given input date value. We use now() function to get the input date value.

SELECT 
NOW() AS 'Current Date and Time', 
MONTH(NOW()) AS 'Month Value';

The result of above query is:

Sample Database Table - BookOrder

SQL MONTH() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate" and "DeliveryDate" from the "BookOrder" table. The MONTH() function will extract the month value(a whole integer number from 1 to 12) from the column "OrderDate" and we will stored that value to a new column called "Order Month" and "Delivery Month".

SELECT 
OrderDate, MONTH(OrderDate) As 'Order Month', 
DeliveryDate, MONTH(DeliveryDate) As 'Delivery Month' 
FROM BookOrder;

The result of above query is: