MySQLdayname（）函数
转载⾃
MySQL DAYNAME函数介绍
MySQL DAYNAME函数返回指定⽇期的⼯作⽇的名称。 以下说明了DAYNAME函数的语法：
DAYNAME(date);
DAYNAME函数接受1个参数，该参数是要获取其⼯作⽇名称的⽇期。
when i look into your eyes如果⽇期为或⽆效，例如2017-02-30，DAYNAME函数将返回NULL。
MySQL DAYNAME函数⽰例
以下⽰例将返回2018年1⽉1⽇的⼯作⽇名称。
mysql> SELECT DAYNAME('2018-01-01') dayname;
reveals+---------+
愿望成真 英文
| dayname |
+---------+
| Monday |
+---------+
1 row in t
默认情况下，MySQL返回由lc_time_names系统变量控制的语⾔中的⼯作⽇的名称，查询当前lc_time_names变量设置的值，如下 -
mysql> SELECT @@lc_time_names;
+-----------------+
| @@lc_time_names |answer什么意思
+-----------------+
| en_US |
+-----------------+
1 row in t
您可以看到，⽬前区域设置设置为en_US。
要在特定区域设置中获取⽇期名称⼀个⼯作⽇，您需要更改lc_time_names变量的值。 例如，以下语句将语⾔环境设置为中⽂：
mysql> SET @@lc_time_names = 'zh_CN';
Query OK, 0 rows affected
现在，我们来查询2018年1⽉1⽇的⼯作⽇名称：
mysql> SELECT DAYNAME('2018-01-01') dayname;
+---------+
| dayname |
+---------+
| 星期⼀ |
+---------+
1 row in t
您可以看到，⼯作⽇名称已更改为中⽂：星期⼀。
下表显⽰了MySQL所⽀持的lc_time_names系统变量的有效语⾔环境的值：
国家编/代码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 Chine – China zh_CN Chine – Hong Kong zh_HK Chine – 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
egoistFaroe – 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 Japane – 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 国家编/代码
Portuge – Brazil pt_BR Portuge – 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
国家编/代码Vietname – Viet Nam vi_VN
请参阅中的以下orders表：
mysql> desc orders;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| orderNumber | int(11) | NO | PRI | NULL | |
| orderDate | date | NO | | NULL | |
| requiredDate | date | NO | | NULL | |
| shippedDate | date | YES | | NULL | |
| status | varchar(15) | NO | | NULL | |
archive
| comments | text | YES | | NULL | |
| customerNumber | int(11) | NO | MUL | NULL | |
+----------------+-------------+------+-----+---------+-------+
7 rows in t
以下语句返回2014年按⼯作⽇名称分组的订单计数。
SELECT
DAYNAME(orderdate) weekday,
COUNT(*) total_orders
FROM
orders
WHERE
YEAR(orderdate) = 2004
GROUP BY weekday
ORDER BY total_orders DESC;
执⾏上⾯查询语句，得到以下结果 -
+---------+--------------+
| weekday | total_orders |
+---------+--------------+
| 星期三 | 37 |
| 星期⼀ | 28 |
joinin
| 星期⽇ | 27 |
| 星期⼆ | 22 |
| 星期六 | 21 |预约报名
| 星期四 | 14 |
流水线英文
| 星期五 | 2 |
+---------+--------------+
7 rows in t
星期三的订单数量是最⾼的，星期五有两个订单。
在本教程中，您已经学习了如何使⽤MySQL DAYNAME函数获取特定⽇期的⼯作⽇名称。
