Collections:
DAYNAME() - Name of Weekday
How to obtain the name of weekday of a given date using the DAYNAME() function?
✍: FYIcenter.com
DAYNAME(date) is a MySQL built-in function that
returns the name of weekday from a given date.
For example:
SELECT DAYNAME('2023-02-03'), DAYNAME(NOW());
-- +-----------------------+----------------+
-- | DAYNAME('2023-02-03') | DAYNAME(NOW()) |
-- +-----------------------+----------------+
-- | Friday | Tuesday |
-- +-----------------------+----------------+
Reference information of the DAYNAME() function:
DAYNAME(date): str Returns the name of the weekday 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 weekday from. str: Return value. The name of weekday. Available since MySQL 4.
⇐ DAY() - Synonym for DAYOFMONTH()
2023-11-16, 2037🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...