MySQL numeric functions

• ABS
• SQRT
• MOD
• CEIL and CEILING
• FLOOR
• RAND
• ROUND
• SIGN
• POW and POWER
• SIN
• ASIN
• COS
• ACOS
• TAN
• ATAN
• COT

MySQL string functions

• LENGTH
• CONCAT
• INSERT
• LOWER
• UPPER
• LEFT
• RIGHT
• TRIM
• REPLACE
• SUBSTRING
• REVERSE

MySQL Date/Time functions

• CURDATE and CURRENT_DATE
• CURTIME and CURRENT_TIME
• NOW and SYSDATE
• UNIX_TIMESTAMP
• FROM_UNIXTIME
• MONTH
• MONTHNAME
• DAYNAME
• DAYOFWEEK
• WEEK
• DAYOFYEAR
• DAYOFMONTH
• YEAR
• TIME_TO_SEC
• SEC_TO_TIME
• DATE_ADD and ADDDATE
• DATE_SUB and SUBDATE
• ADDTIME
• SUBTIME
• DATEDIFF
• DATE_FORMAT
• WEEKDAY

MySQL aggregate functions

• MAX
• MIN
• COUNT
• SUM
• AVG

MySQL flow control functions

• IF
• IFNULL
• CASE

MySQL MONTHNAME Function: Get The English Name Of The Specified Date And Month

The MONTHNAME() function in MySQL is a date function that returns the name of the month for a given date.

Syntax:

MONTHNAME(date)

Here, date is a valid date expression.

Example:

SELECT MONTHNAME('2023-05-12');

This will return May, because the month in the provided date is May.

Usage in a Table:

Consider the following orders table:

If you want to select all orders along with the name of the month in which they were placed, you can use the MONTHNAME() function:

SELECT OrderID, Product, MONTHNAME(OrderDate) as Month
FROM orders;

This will return:

Usage with GROUP BY:

You can use the MONTHNAME() function with the GROUP BY clause to group orders by month. For example, if you want to count the number of orders placed in each month, you could do this:

SELECT MONTHNAME(OrderDate) AS OrderMonth, COUNT(*) AS NumberOfOrders
FROM orders
GROUP BY OrderMonth;

This will return a result set with the number of orders placed in each month.

Remember that the MONTHNAME() function will return NULL if the input is not a valid date expression.

1. MySQL MONTHNAME Function Example:

   • Description: The MONTHNAME function in MySQL is used to extract the month name from a date.
   • Example Code:

     SELECT MONTHNAME(date_column) AS month_name
     FROM table_name;
     

2. How to Use MONTHNAME Function in MySQL:

   • Description: Use the MONTHNAME function to retrieve the English month name from a date.
   • Example Code:

     SELECT MONTHNAME('2023-04-15') AS month_name;
     

3. Getting the English Month Name with MONTHNAME in MySQL:

   • Description: MONTHNAME is used to get the English month name from a date.
   • Example Code:

     SELECT order_id, MONTHNAME(order_date) AS month_name
     FROM orders;
     

4. Extracting Month Names from Date Values in MySQL:

   • Description: Use the MONTHNAME function to extract month names from date values in a table.
   • Example Code:

     SELECT employee_name, MONTHNAME(hire_date) AS hire_month_name
     FROM employees;
     

5. MONTHNAME Function with WHERE Clause in MySQL:

   • Description: Apply the MONTHNAME function with a WHERE clause to filter records based on the month name condition.
   • Example Code:

     SELECT customer_name, order_date
     FROM orders
     WHERE MONTHNAME(order_date) = 'June'; -- Select orders in June
     

6. Handling NULL Values with MONTHNAME Function in MySQL:

   • Description: The MONTHNAME function handles NULL values gracefully. If the date is NULL, the result is also NULL.
   • Example Code:

     SELECT customer_name, MONTHNAME(last_purchase_date) AS last_purchase_month_name
     FROM customers;
     

7. Examples of Using MONTHNAME Function in MySQL Queries:

   • Description: Various examples showcasing the application of the MONTHNAME function in different scenarios.
   • Example Code:

     SELECT product_name, MONTHNAME(release_date) AS release_month_name
     FROM products;
     

     SELECT employee_id, MONTHNAME(birthdate) AS birth_month_name
     FROM employees
     WHERE MONTHNAME(birthdate) = 'December'; -- Select employees born in December
     

8. Using MONTHNAME with Date Formatting in MySQL:

   • Description: Combine MONTHNAME with date formatting functions for customized output.
   • Example Code:

     SELECT order_id, CONCAT('Month: ', MONTHNAME(order_date)) AS formatted_month_name
     FROM orders;