Articles/SQL

MONTH() in MySQL — How It Works

What the MySQL MONTH() function does, with an example.

Published October 20, 2026

MONTH() extracts the month (1-12) from a date value.

Key points

  • Part of standard SQL functions available in MySQL for working with dates and times

Example

SELECT MONTH(created_at) FROM orders;
More SQL articles