Collections:
MONTHNAME() - Name of Month
How to obtain the name of month of a given date using the MONTHNAME() function?
✍: FYIcenter.com
MONTHNAME(date) is a MySQL built-in function that returns the name of month from a given date. For example:
SELECT MONTHNAME('2023-02-03'), MONTHNAME(NOW()); -- +-------------------------+------------------+ -- | MONTHNAME('2023-02-03') | MONTHNAME(NOW()) | -- +-------------------------+------------------+ -- | February | November | -- +-------------------------+------------------+
Reference information of the MONTHNAME() function:
MONTHNAME(date): str Returns the full name of the month for date. The language used for the name is controlled by the value of the lc_time_names system variable. Arguments, return value and availability: date: Required. The date to extract the name of month from. str: Return value. The name of month. Available since MySQL 4.
⇒ NOW() - Start Time of Execution
2023-11-17, 252🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...