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, 254🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...