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, 255🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...