Server Locale

La variabile lc_time_names determina il linguaggio utilizzato dalle funzioni di data e ora DAYNAME(), MONTHNAME() e DATE_FORMAT().

MariaDB supporta i seguenti valori:

ar_AE: Arabic - United Arab Emiratesar_BH: Arabic - Bahrain
ar_DZ: Arabic - Algeriaar_EG: Arabic - Egypt
ar_IN: Arabic - Indiaar_IQ: Arabic - Iraq
ar_JO: Arabic - Jordanar_KW: Arabic - Kuwait
ar_LB: Arabic - Lebanonar_LY: Arabic - Libya
ar_MA: Arabic - Moroccoar_OM: Arabic - Oman
ar_QA: Arabic - Qatarar_SA: Arabic - Saudi Arabia
ar_SD: Arabic - Sudanar_SY: Arabic - Syria
ar_TN: Arabic - Tunisiaar_YE: Arabic - Yemen
be_BY: Belarusian - Belarusbg_BG: Bulgarian - Bulgaria
ca_ES: Catalan - Spaincs_CZ: Czech - Czech Republic
da_DK: Danish - Denmarkde_AT: German - Austria
de_BE: German - Belgiumde_CH: German - Switzerland
de_DE: German - Germanyde_LU: German - Luxembourg
en_AU: English - Australiaen_CA: English - Canada
en_GB: English - United Kingdomen_IN: English - India
en_NZ: English - New Zealanden_PH: English - Philippines
en_US: English - United Statesen_ZA: English - South Africa
en_ZW: English - Zimbabwees_AR: Spanish - Argentina
es_BO: Spanish - Boliviaes_CL: Spanish - Chile
es_CO: Spanish - Columbiaes_CR: Spanish - Costa Rica
es_DO: Spanish - Dominican Republices_EC: Spanish - Ecuador
es_ES: Spanish - Spaines_GT: Spanish - Guatemala
es_HN: Spanish - Hondurases_MX: Spanish - Mexico
es_NI: Spanish - Nicaraguaes_PA: Spanish - Panama
es_PE: Spanish - Perues_PR: Spanish - Puerto Rico
es_PY: Spanish - Paraguayes_SV: Spanish - El Salvador
es_US: Spanish - United Stateses_UY: Spanish - Uruguay
es_VE: Spanish - Venezuelaet_EE: Estonian - Estonia
eu_ES: Basque - Basquefi_FI: Finnish - Finland
fo_FO: Faroese - Faroe Islandsfr_BE: French - Belgium
fr_CA: French - Canadafr_CH: French - Switzerland
fr_FR: French - Francefr_LU: French - Luxembourg
gl_ES: Galician - Spaingu_IN: Gujarati - India
he_IL: Hebrew - Israelhi_IN: Hindi - India
hr_HR: Croatian - Croatiahu_HU: Hungarian - Hungary
id_ID: Indonesian - Indonesiais_IS: Icelandic - Iceland
it_CH: Italian - Switzerlandit_IT: Italian - Italy
ja_JP: Japanese - Japanko_KR: Korean - Republic of Korea
lt_LT: Lithuanian - Lithuanialv_LV: Latvian - Latvia
mk_MK: Macedonian - FYROMmn_MN: Mongolia - Mongolian
ms_MY: Malay - Malaysianb_NO: Norwegian(Bokmål) - Norway
nl_BE: Dutch - Belgiumnl_NL: Dutch - The Netherlands
no_NO: Norwegian - Norwaypl_PL: Polish - Poland
pt_BR: Portugese - Brazilpt_PT: Portugese - Portugal
ro_RO: Romanian - Romaniaru_RU: Russian - Russia
ru_UA: Russian - Ukrainesk_SK: Slovak - Slovakia
sl_SI: Slovenian - Sloveniasq_AL: Albanian - Albania
sr_YU: Serbian - Yugoslaviasv_FI: Swedish - Finland
sv_SE: Swedish - Swedenta_IN: Tamil - India
te_IN: Telugu - Indiath_TH: Thai - Thailand
tr_TR: Turkish - Turkeyuk_UA: Ukrainian - Ukraine
ur_PK: Urdu - Pakistanvi_VN: Vietnamese - Viet Nam
zh_CN: Chinese - Chinazh_HK: Chinese - Hong Kong
zh_TW: Chinese - Taiwan Province of China

Esempi

MariaDB [(none)]> SELECT DAYNAME('2013-04-01'), MONTHNAME('2013-04-01');
+-----------------------+-------------------------+
| DAYNAME('2013-04-01') | MONTHNAME('2013-04-01') |
+-----------------------+-------------------------+
| Monday                | April                   |
+-----------------------+-------------------------+

MariaDB [(none)]> SET lc_time_names = 'fr_CA';

MariaDB [(none)]> SELECT DAYNAME('2013-04-01'), MONTHNAME('2013-04-01');
+-----------------------+-------------------------+
| DAYNAME('2013-04-01') | MONTHNAME('2013-04-01') |
+-----------------------+-------------------------+
| lundi                 | avril                   |
+-----------------------+-------------------------+

Commenti

Sto caricando i commenti......
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.