MySQL DAYNAME() Function; Through this tutorial, i am going to show you how to get weekday name from date using the MySQL dayname() function with the help of examples.
MySQL DAYNAME() Function
The MySQL DAYNAME function returns the weekday name from a date.
Syntax of MySQL DAYNAME() Function
The mysql dayname() function syntax; as shown below:
DAYNAME(date)
Here date is the date value that you want return the weekday name from.
Examples 1 – MySQL DAYNAME() Function
Now, i will take first example to get day name from a date using dayname function in mysql; as follows:
SELECT DAYNAME('2019-07-11') AS 'Result';
Output-1
+---------+ | Result | +---------+ |Thursday | +---------+
Examples 2 – MySQL DAYNAME() Function
To fetch a record / data from the mysql database table with week day name using mysql query; as follows:
SELECT created_at AS create_date, DAYNAME(created_at) AS week_day_name FROM users WHERE id = 1;
Output-2
+---------------------+--------------+ | create_date |week_day_name | +---------------------+--------------+ | 2019-07-11 11:30:37 | Thursday | +---------------------+--------------+
Examples 3 – MySQL DAYNAME() with Now() Function
Current date with DAYNAME() function. It will return weekday name from the current date & time; as follows:
SELECT NOW(), DAYNAME(NOW());
Output-3
+---------------------+----------------+ | NOW() | DAYNAME(NOW()) | +---------------------+----------------+ | 2018-07-11 19:05:41 | Thursday | +---------------------+----------------+
Examples 4 – MySQL DAYNAME() with CURDATE() Function
Take an example using DAYNAME() with CURDATE() function. Which is returns only the weekday name; as follows:
SELECT
CURDATE(),
DAYNAME(CURDATE());
Output-4
+------------+--------------------+ | CURDATE() | DAYNAME(CURDATE()) | +------------+--------------------+ | 2019-07-11 | Thursday | +------------+--------------------+
Examples 5 – MySQL DAYNAME() with Local() Function
The language used for the month name is controlled by the lc_time_names system variable. Here’s an example of changing the value of that variable, and then running DAYNAME() again.
SET lc_time_names = 'fr_FR';
SELECT DAYNAME('2021-12-07') AS 'Result';
Output-5
+-----------+ | Result | +-----------+ | lundi | +-----------+
In this example, We changed the lc_time_names variable to fr_FR which means French – France.
List of MySQL locale
The following table shows the valid locales for lc_time_names supported by MySQL:
| Albanian – Albania | sq_AL |
| Arabic – Algeria | ar_DZ |
| Arabic – Bahrain | ar_BH |
| Arabic – Egypt | ar_EG |
| Arabic – India | ar_IN |
| Arabic – Iraq | ar_IQ |
| Arabic – Jordan | ar_JO |
| Arabic – Kuwait | ar_KW |
| Arabic – Lebanon | ar_LB |
| Arabic – Libya | ar_LY |
| Arabic – Morocco | ar_MA |
| Arabic – Oman | ar_OM |
| Arabic – Qatar | ar_QA |
| Arabic – Saudi Arabia | ar_SA |
| Arabic – Sudan | ar_SD |
| Arabic – Syria | ar_SY |
| Arabic – Tunisia | ar_TN |
| Arabic – United Arab Emirates | ar_AE |
| Arabic – Yemen | ar_YE |
| Basque – Basque | eu_ES |
| Belarusian – Belarus | be_BY |
| Bulgarian – Bulgaria | bg_BG |
| Catalan – Spain | ca_ES |
| Chinese – China | zh_CN |
| Chinese – Hong Kong | zh_HK |
| Chinese – Taiwan Province of China | zh_TW |
| Croatian – Croatia | hr_HR |
| Czech – Czech Republic | cs_CZ |
| Danish – Denmark | da_DK |
| Dutch – Belgium | nl_BE |
| Dutch – The Netherlands | nl_NL |
| English – Australia | en_AU |
| English – Canada | en_CA |
| English – India | en_IN |
| English – New Zealand | en_NZ |
| English – Philippines | en_PH |
| English – South Africa | en_ZA |
| English – United Kingdom | en_GB |
| English – United States | en_US |
| English – Zimbabwe | en_ZW |
| Estonian – Estonia | et_EE |
| Faroese – Faroe Islands | fo_FO |
| Finnish – Finland | fi_FI |
| French – Belgium | fr_BE |
| French – Canada | fr_CA |
| French – France | fr_FR |
| French – Luxembourg | fr_LU |
| French – Switzerland | fr_CH |
| Galician – Spain | gl_ES |
| German – Austria | de_AT |
| German – Belgium | de_BE |
| German – Germany | de_DE |
| German – Luxembourg | de_LU |
| German – Switzerland | de_CH |
| Greek – Greece | el_GR |
| Gujarati – India | gu_IN |
| Hebrew – Israel | he_IL |
| Hindi – India | hi_IN |
| Hungarian – Hungary | hu_HU |
| Icelandic – Iceland | is_IS |
| Indonesian – Indonesia | id_ID |
| Italian – Italy | it_IT |
| Italian – Switzerland | it_CH |
| Japanese – Japan | ja_JP |
| Korean – Republic of Korea | ko_KR |
| Latvian – Latvia | lv_LV |
| Lithuanian – Lithuania | lt_LT |
| Macedonian – FYROM | mk_MK |
| Malay – Malaysia | ms_MY |
| Mongolia – Mongolian | mn_MN |
| Norwegian – Norway | no_NO |
| Norwegian(Bokmål) – Norway | nb_NO |
| Polish – Poland | pl_PL |
| Portugese – Brazil | pt_BR |
| Portugese – Portugal | pt_PT |
| Romanian – Romania | ro_RO |
| Russian – Russia | ru_RU |
| Russian – Ukraine | ru_UA |
| Serbian – Yugoslavia | sr_RS |
| Slovak – Slovakia | sk_SK |
| Slovenian – Slovenia | sl_SI |
| Spanish – Argentina | es_AR |
| Spanish – Bolivia | es_BO |
| Spanish – Chile | es_CL |
| Spanish – Columbia | es_CO |
| Spanish – Costa Rica | es_CR |
| Spanish – Dominican Republic | es_DO |
| Spanish – Ecuador | es_EC |
| Spanish – El Salvador | es_SV |
| Spanish – Guatemala | es_GT |
| Spanish – Honduras | es_HN |
| Spanish – Mexico | es_MX |
| Spanish – Nicaragua | es_NI |
| Spanish – Panama | es_PA |
| Spanish – Paraguay | es_PY |
| Spanish – Peru | es_PE |
| Spanish – Puerto Rico | es_PR |
| Spanish – Spain | es_ES |
| Spanish – United States | es_US |
| Spanish – Uruguay | es_UY |
| Spanish – Venezuela | es_VE |
| Swedish – Finland | sv_FI |
| Swedish – Sweden | sv_SE |
| Tamil – India | ta_IN |
| Telugu – India | te_IN |
| Thai – Thailand | th_TH |
| Turkish – Turkey | tr_TR |
| Ukrainian – Ukraine | uk_UA |
| Urdu – Pakistan | ur_PK |
| Vietnamese – Viet Nam | vi_VN |
Conclusion
Through this tutorial, You have learned how to use DAYNAME() function with various examples.