Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql
mysql
monthname
communitycreator

What is MONTHNAME() in SQL?

Harris Amjad

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

The MONTHNAME() function returns the name of the month from a date sent as a parameter.

Figure 1 shows a visual representation of the MONTHNAME() function and the month numbers.

Figure 1: Visual representation of MONTHNAME() function and the month numbers

Syntax

MONTHNAME(date)

Parameter

The MONTHNAME() function takes the date as a parameter.

Dates must be in the format YYYY-MM-DD, or else this function returns NULL.

Return value

The MONTHNAME() function returns the name of the month from a date sent as a parameter.

It returns NULL if the month part of the date is equal to 0 or greater than 12.

Example

The following example shows how we can get the month from the admission dates of students using the MONTHNAME() function.

Students

Student ID

Student Name

Student Admission Date

1

David

2000-07-14

2

Luiss

2002-08-15

3

Harvey

2005-04-19

4

Lucy

2010-01-27

5

Andrew

2011-10-03

SELECT *, MONTHNAME(studentAdmissionDate) as MonthName
from Students;

RELATED TAGS

sql
mysql
monthname
communitycreator

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

Keep Exploring