Beginner

272. MONTH Function

Learn how to extract the month from a date.

📘 Lesson 272 of 728 ⏱ 8 min 🎯 Beginner

The MONTH function returns the month component of a date, normally as a number from 1 through 12.

Month information is essential for monthly reporting, seasonal analysis, sales trends, and business performance comparisons.

Extract the month from each sales transaction.

SQL 
SELECT
    OrderID,
    MONTH(OrderDate) AS OrderMonth
FROM Orders;

MONTH is widely used for monthly sales analysis, financial reporting, customer activity analysis, and trend reporting.

  • MONTH extracts the month number.
  • The result is normally between 1 and 12.
  • It is useful for monthly analysis.
  • It can be used with GROUP BY.
  • Database-specific alternatives may exist.
What does MONTH return?

MONTH returns the month component of a date, normally as a number from 1 to 12.

Why is MONTH useful for Data Analysts?

It allows analysts to group and compare business activity by month.

Have you finished this lesson?

Introduction to SQL – All Lessons