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, 246🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...