SharePoint区域设置对应的时间格式

今天碰到一个有意思的问题，就顺便借用了这里的一段示例代码，稍作修改，导出个不同地区，文化下的时间格式。

 

    class Program
    {
        static void Main(string[] args)
        {
            List<string> list = new List<string>();
            foreach (CultureInfo ci in CultureInfo.GetCultures(CultureTypes.AllCultures))
            {
                string specName = "(none)";
                string datePattern = "(none)";
                try
                {
                    specName = CultureInfo.CreateSpecificCulture(ci.Name).Name;
                    datePattern = ci.DateTimeFormat.ShortDatePattern;
                }
                catch { }

                list.Add(String.Format("{0,-12}{1,-12}{2,-12}{3}", ci.Name, specName, datePattern, ci.EnglishName));
            }
            list.Sort();
            // write to console
            Console.WriteLine("CULTURE   SPEC.CULTURE  DateTime Format         ENGLISH NAME ");
            foreach (string str in list)
            {
                Console.WriteLine(str);
            }
            Console.Read();
        }
    }

 

 

CULTURE	SPEC.CULTURE	Format	ENGLISH NAME
af	af-ZA	(none)	Afrikaans
af-ZA	af-ZA	yyyy/MM/dd	Afrikaans (South Africa)
am-ET	am-ET	d/M/yyyy	Amharic (Ethiopia)
ar	ar-SA	(none)	Arabic
ar-AE	ar-AE	dd/MM/yyyy	Arabic (U.A.E.)
ar-BH	ar-BH	dd/MM/yyyy	Arabic (Bahrain)
ar-DZ	ar-DZ	dd-MM-yyyy	Arabic (Algeria)
ar-EG	ar-EG	dd/MM/yyyy	Arabic (Egypt)
ar-IQ	ar-IQ	dd/MM/yyyy	Arabic (Iraq)
ar-JO	ar-JO	dd/MM/yyyy	Arabic (Jordan)
ar-KW	ar-KW	dd/MM/yyyy	Arabic (Kuwait)
ar-LB	ar-LB	dd/MM/yyyy	Arabic (Lebanon)
ar-LY	ar-LY	dd/MM/yyyy	Arabic (Libya)
ar-MA	ar-MA	dd-MM-yyyy	Arabic (Morocco)
arn-CL	arn-CL	dd-MM-yyyy	Mapudungun (Chile)
ar-OM	ar-OM	dd/MM/yyyy	Arabic (Oman)
ar-QA	ar-QA	dd/MM/yyyy	Arabic (Qatar)
ar-SA	ar-SA	dd/MM/yy	Arabic (Saudi Arabia)
ar-SY	ar-SY	dd/MM/yyyy	Arabic (Syria)
ar-TN	ar-TN	dd-MM-yyyy	Arabic (Tunisia)
ar-YE	ar-YE	dd/MM/yyyy	Arabic (Yemen)
as-IN	as-IN	dd-MM-yyyy	Assamese (India)
az	az-Latn-AZ	(none)	Azeri
az-Cyrl-AZ	az-Cyrl-AZ	dd.MM.yyyy	Azeri (Cyrillic, Azerbaijan)
az-Latn-AZ	az-Latn-AZ	dd.MM.yyyy	Azeri (Latin, Azerbaijan)
ba-RU	ba-RU	dd.MM.yy	Bashkir (Russia)
be	be-BY	(none)	Belarusian
be-BY	be-BY	dd.MM.yyyy	Belarusian (Belarus)
bg	bg-BG	(none)	Bulgarian
bg-BG	bg-BG	dd.M.yyyy	'г.'Bulgarian (Bulgaria)
bn-BD	bn-BD	dd-MM-yy	Bangla (Bangladesh)
bn-IN	bn-IN	dd-MM-yy	Bangla (India)
bo-CN	bo-CN	yyyy/M/d	Tibetan (China)
br-FR	br-FR	dd/MM/yyyy	Breton (France)
bs-Cyrl-BA	bs-Cyrl-BA	d.M.yyyy	Bosnian (Cyrillic) (Bosnia and Herzegovina)
bs-Latn-BA	bs-Latn-BA	d.M.yyyy	Bosnian (Latin) (Bosnia and Herzegovina)
ca	ca-ES	(none)	Catalan
ca-ES	ca-ES	dd/MM/yyyy	Catalan (Catalan)
ca-ES-valenc	iaca-ES-vale	nciadd/MM/	yy Valencian (Spain)
chr-Cher-US	chr-Cher-US	M/d/yyyy	Cherokee (United States)
co-FR	co-FR	dd/MM/yyyy	Corsican (France)
cs	cs-CZ	(none)	Czech
cs-CZ	cs-CZ	d.M.yyyy	Czech (Czech Republic)
cy-GB	cy-GB	dd/MM/yy	Welsh (United Kingdom)
da	da-DK	(none)	Danish
da-DK	da-DK	dd-MM-yyyy	Danish (Denmark)
de	de-DE	(none)	German
de-AT	de-AT	dd.MM.yyyy	German (Austria)
de-CH	de-CH	dd.MM.yyyy	German (Switzerland)
de-DE	de-DE	dd.MM.yyyy	German (Germany)
de-LI	de-LI	dd.MM.yyyy	German (Liechtenstein)
de-LU	de-LU	dd.MM.yyyy	German (Luxembourg)
dsb-DE	dsb-DE	d. M. yyyy	Lower Sorbian (Germany)
dv	dv-MV	(none)	Divehi
dv-MV	dv-MV	dd/MM/yy	Divehi (Maldives)
el	el-GR	(none)	Greek
el-GR	el-GR	d/M/yyyy	Greek (Greece)
en	en-US	(none)	English
en-029	en-029	MM/dd/yyyy	English (Caribbean)
en-AU	en-AU	d/MM/yyyy	English (Australia)
en-BZ	en-BZ	dd/MM/yyyy	English (Belize)
en-CA	en-CA	dd/MM/yyyy	English (Canada)
en-GB	en-GB	dd/MM/yyyy	English (United Kingdom)
en-IE	en-IE	dd/MM/yyyy	English (Ireland)
en-IN	en-IN	dd-MM-yyyy	English (India)
en-JM	en-JM	dd/MM/yyyy	English (Jamaica)
en-MY	en-MY	d/M/yyyy	English (Malaysia)
en-NZ	en-NZ	d/MM/yyyy	English (New Zealand)
en-PH	en-PH	M/d/yyyy	English (Republic of the Philippines)
en-SG	en-SG	d/M/yyyy	English (Singapore)
en-TT	en-TT	dd/MM/yyyy	English (Trinidad and Tobago)
en-US	en-US	M/d/yyyy	English (United States)
en-ZA	en-ZA	yyyy/MM/dd	English (South Africa)
en-ZW	en-ZW	M/d/yyyy	English (Zimbabwe)
es	es-ES	(none)	Spanish
es-AR	es-AR	dd/MM/yyyy	Spanish (Argentina)
es-BO	es-BO	dd/MM/yyyy	Spanish (Bolivia)
es-CL	es-CL	dd-MM-yyyy	Spanish (Chile)
es-CO	es-CO	dd/MM/yyyy	Spanish (Colombia)
es-CR	es-CR	dd/MM/yyyy	Spanish (Costa Rica)
es-DO	es-DO	dd/MM/yyyy	Spanish (Dominican Republic)
es-EC	es-EC	dd/MM/yyyy	Spanish (Ecuador)
es-ES	es-ES	dd/MM/yyyy	Spanish (Spain)
es-GT	es-GT	dd/MM/yyyy	Spanish (Guatemala)
es-HN	es-HN	dd/MM/yyyy	Spanish (Honduras)
es-MX	es-MX	dd/MM/yyyy	Spanish (Mexico)
es-NI	es-NI	dd/MM/yyyy	Spanish (Nicaragua)
es-PA	es-PA	MM/dd/yyyy	Spanish (Panama)
es-PE	es-PE	dd/MM/yyyy	Spanish (Peru)
es-PR	es-PR	dd/MM/yyyy	Spanish (Puerto Rico)
es-PY	es-PY	dd/MM/yyyy	Spanish (Paraguay)
es-SV	es-SV	dd/MM/yyyy	Spanish (El Salvador)
es-US	es-US	M/d/yyyy	Spanish (United States)
es-UY	es-UY	dd/MM/yyyy	Spanish (Uruguay)
es-VE	es-VE	dd/MM/yyyy	Spanish (Venezuela)
et	et-EE	(none)	Estonian
et-EE	et-EE	d.MM.yyyy	Estonian (Estonia)
eu	eu-ES	(none)	Basque
eu-ES	eu-ES	yyyy/MM/dd	Basque (Basque)
fa	fa-IR	(none)	Persian
fa-IR	fa-IR	yyyy/MM/dd	Persian (Iran)
ff-Latn-SN	ff-Latn-SN	dd/MM/yyyy	Fulah (Senegal)
fi	fi-FI	(none)	Finnish
fi-FI	fi-FI	d.M.yyyy	Finnish (Finland)
fil-PH	fil-PH	M/d/yyyy	Filipino (Philippines)
fo	fo-FO	(none)	Faroese
fo-FO	fo-FO	dd-MM-yyyy	Faroese (Faroe Islands)
fr	fr-FR	(none)	French
fr-BE	fr-BE	d/MM/yyyy	French (Belgium)
fr-CA	fr-CA	yyyy-MM-dd	French (Canada)
fr-CH	fr-CH	dd.MM.yyyy	French (Switzerland)
fr-FR	fr-FR	dd/MM/yyyy	French (France)
fr-LU	fr-LU	dd/MM/yyyy	French (Luxembourg)
fr-MC	fr-MC	dd/MM/yyyy	French (Principality of Monaco)
fy-NL	fy-NL	d-M-yyyy	Frisian (Netherlands)
ga-IE	ga-IE	dd/MM/yyyy	Irish (Ireland)
gd-GB	gd-GB	dd/MM/yyyy	Scottish Gaelic (United Kingdom)
gl	gl-ES	(none)	Galician
gl-ES	gl-ES	dd/MM/yy	Galician (Galician)
gsw-FR	gsw-FR	dd/MM/yyyy	Alsatian (France)
gu	gu-IN	(none)	Gujarati
gu-IN	gu-IN	dd-MM-yy	Gujarati (India)
ha-Latn-NG	ha-Latn-NG	d/M/yyyy	Hausa (Latin) (Nigeria)
haw-US	haw-US	M/d/yyyy	Hawaiian (United States)
he	he-IL	(none)	Hebrew
he-IL	he-IL	dd/MM/yyyy	Hebrew (Israel)
hi	hi-IN	(none)	Hindi
hi-IN	hi-IN	dd-MM-yyyy	Hindi (India)
hr	hr-HR	(none)	Croatian
hr-BA	hr-BA	d.M.yyyy.	Croatian (Latin) (Bosnia and Herzegovina)
hr-HR	hr-HR	d.M.yyyy	Croatian (Croatia)
hsb-DE	hsb-DE	d. M. yyyy	Upper Sorbian (Germany)
hu	hu-HU	(none)	Hungarian
hu-HU	hu-HU	yyyy. MM.	dd.Hungarian (Hungary)
hy	hy-AM	(none)	Armenian
hy-AM	hy-AM	dd.MM.yyyy	Armenian (Armenia)
id	id-ID	(none)	Indonesian
id-ID	id-ID	dd/MM/yyyy	Indonesian (Indonesia)
ig-NG	ig-NG	d/M/yyyy	Igbo (Nigeria)
ii-CN	ii-CN	yyyy/M/d	Yi (China)
is	is-IS	(none)	Icelandic
is-IS	is-IS	d.M.yyyy	Icelandic (Iceland)
it	it-IT	(none)	Italian
it-CH	it-CH	dd.MM.yyyy	Italian (Switzerland)
it-IT	it-IT	dd/MM/yyyy	Italian (Italy)
iu-Cans-CA	iu-Cans-CA	d/M/yyyy	Inuktitut (Syllabics) (Canada)
iu-Latn-CA	iu-Latn-CA	d/MM/yyyy	Inuktitut (Latin) (Canada)
ja	ja-JP	(none)	Japanese
ja-JP	ja-JP	yyyy/MM/dd	Japanese (Japan)
ka	ka-GE	(none)	Georgian
ka-GE	ka-GE	dd.MM.yyyy	Georgian (Georgia)
kk	kk-KZ	(none)	Kazakh
kk-KZ	kk-KZ	dd.MM.yyyy	Kazakh (Kazakhstan)
kl-GL	kl-GL	dd-MM-yyyy	Greenlandic (Greenland)
km-KH	km-KH	yyyy-MM-dd	Khmer (Cambodia)
kn	kn-IN	(none)	Kannada
kn-IN	kn-IN	dd-MM-yy	Kannada (India)
ko	ko-KR	(none)	Korean
kok	kok-IN	(none)	Konkani
kok-IN	kok-IN	dd-MM-yyyy	Konkani (India)
ko-KR	ko-KR	yyyy-MM-dd	Korean (Korea)
ku-Arab-IQ	ku-Arab-IQ	yyyy/MM/dd	Central Kurdish (Iraq)
ky	ky-KG	(none)	Kyrgyz
ky-KG	ky-KG	dd.MM.yy	Kyrgyz (Kyrgyzstan)
lb-LU	lb-LU	dd.MM.yy	Luxembourgish (Luxembourg)
lo-LA	lo-LA	dd/MM/yyyy	Lao (Lao PDR)
lt	lt-LT	(none)	Lithuanian
lt-LT	lt-LT	yyyy.MM.dd	Lithuanian (Lithuania)
lv	lv-LV	(none)	Latvian
lv-LV	lv-LV	yyyy.MM.dd	. Latvian (Latvia)
mi-NZ	mi-NZ	dd/MM/yyyy	Maori (New Zealand)
mk	mk-MK	(none)	Macedonian
mk-MK	mk-MK	dd.MM.yyyy	Macedonian (Former Yugoslav Republic of Macedonia)
ml-IN	ml-IN	dd-MM-yy	Malayalam (India)
mn	mn-MN	(none)	Mongolian
mn-MN	mn-MN	yy.MM.dd	Mongolian (Cyrillic, Mongolia)
mn-Mong-CN	mn-Mong-CN	yyyy/M/d	Mongolian (Traditional Mongolian) (China)
moh-CA	moh-CA	M/d/yyyy	Mohawk (Canada)
mr	mr-IN	(none)	Marathi
mr-IN	mr-IN	dd-MM-yyyy	Marathi (India)
ms	ms-MY	(none)	Malay
ms-BN	ms-BN	dd/MM/yyyy	Malay (Brunei Darussalam)
ms-MY	ms-MY	dd/MM/yyyy	Malay (Malaysia)
mt-MT	mt-MT	dd/MM/yyyy	Maltese (Malta)
nb-NO	nb-NO	dd.MM.yyyy	Norwegian, Bokm?l (Norway)
ne-NP	ne-NP	M/d/yyyy	Nepali (Nepal)
nl	nl-NL	(none)	Dutch
nl-BE	nl-BE	d/MM/yyyy	Dutch (Belgium)
nl-NL	nl-NL	d-M-yyyy	Dutch (Netherlands)
nn-NO	nn-NO	dd.MM.yyyy	Norwegian, Nynorsk (Norway)
no	nb-NO	(none)	Norwegian
nso-ZA	nso-ZA	dd/MM/yy	Sesotho sa Leboa (South Africa)
oc-FR	oc-FR	dd/MM/yyyy	Occitan (France)
or-IN	or-IN	dd-MM-yy	Odia (India)
pa	pa-IN	(none)	Punjabi
pa-Arab-PK	pa-Arab-PK	dd-MM-yy	Punjabi (Pakistan)
pa-IN	pa-IN	dd-MM-yy	Punjabi (India)
pl	pl-PL	(none)	Polish
pl-PL	pl-PL	yyyy-MM-dd	Polish (Poland)
prs-AF	prs-AF	dd/MM/yy	Dari (Afghanistan)
ps-AF	ps-AF	dd/MM/yy	Pashto (Afghanistan)
pt	pt-BR	(none)	Portuguese
pt-BR	pt-BR	d/M/yyyy	Portuguese (Brazil)
pt-PT	pt-PT	dd-MM-yyyy	Portuguese (Portugal)
qut-GT	qut-GT	dd/MM/yyyy	K'iche' (Guatemala)
quz-BO	quz-BO	dd/MM/yyyy	Quechua (Bolivia)
quz-EC	quz-EC	dd/MM/yyyy	Quichua (Ecuador)
quz-PE	quz-PE	dd/MM/yyyy	Quechua (Peru)
rm-CH	rm-CH	dd-MM-yyyy	Romansh (Switzerland)
ro	ro-RO	(none)	Romanian
ro-RO	ro-RO	dd.MM.yyyy	Romanian (Romania)
ru	ru-RU	(none)	Russian
ru-RU	ru-RU	dd.MM.yyyy	Russian (Russia)
rw-RW	rw-RW	d/MM/yyyy	Kinyarwanda (Rwanda)
sa	sa-IN	(none)	Sanskrit
sah-RU	sah-RU	dd.MM.yyyy	Sakha (Russia)
sa-IN	sa-IN	dd-MM-yyyy	Sanskrit (India)
sd-Arab-PK	sd-Arab-PK	dd/MM/yyyy	Sindhi (Pakistan)
se-FI	se-FI	d.M.yyyy	Sami (Northern) (Finland)
se-NO	se-NO	dd.MM.yyyy	Sami (Northern) (Norway)
se-SE	se-SE	yyyy-MM-dd	Sami (Northern) (Sweden)
si-LK	si-LK	yyyy-MM-dd	Sinhala (Sri Lanka)
sk	sk-SK	(none)	Slovak
sk-SK	sk-SK	d. M. yyyy	Slovak (Slovakia)
sl	sl-SI	(none)	Slovenian
sl-SI	sl-SI	d.M.yyyy	Slovenian (Slovenia)
sma-NO	sma-NO	dd.MM.yyyy	Sami (Southern) (Norway)
sma-SE	sma-SE	yyyy-MM-dd	Sami (Southern) (Sweden)
smj-NO	smj-NO	dd.MM.yyyy	Sami (Lule) (Norway)
smj-SE	smj-SE	yyyy-MM-dd	Sami (Lule) (Sweden)
smn-FI	smn-FI	d.M.yyyy	Sami (Inari) (Finland)
sms-FI	sms-FI	d.M.yyyy	Sami (Skolt) (Finland)
sq	sq-AL	(none)	Albanian
sq-AL	sq-AL	yyyy-MM-dd	Albanian (Albania)
sr	sr-Latn-CS	(none)	Serbian
sr-Cyrl-BA	sr-Cyrl-BA	d.M.yyyy.	Serbian (Cyrillic) (Bosnia and Herzegovina)
sr-Cyrl-CS	sr-Cyrl-CS	d.M.yyyy	Serbian (Cyrillic, Serbia and Montenegro (Former))
sr-Cyrl-ME	sr-Cyrl-ME	d.M.yyyy.	Serbian (Cyrillic) (Montenegro)
sr-Cyrl-RS	sr-Cyrl-RS	d.M.yyyy.	Serbian (Cyrillic) (Serbia)
sr-Latn-BA	sr-Latn-BA	d.M.yyyy.	Serbian (Latin) (Bosnia and Herzegovina)
sr-Latn-CS	sr-Latn-CS	d.M.yyyy	Serbian (Latin, Serbia and Montenegro (Former))
sr-Latn-ME	sr-Latn-ME	d.M.yyyy.	Serbian (Latin) (Montenegro)
sr-Latn-RS	sr-Latn-RS	d.M.yyyy.	Serbian (Latin) (Serbia)
sv	sv-SE	(none)	Swedish
sv-FI	sv-FI	d.M.yyyy	Swedish (Finland)
sv-SE	sv-SE	yyyy-MM-dd	Swedish (Sweden)
sw	sw-KE	(none)	Kiswahili
sw-KE	sw-KE	M/d/yyyy	Kiswahili (Kenya)
syr	syr-SY	(none)	Syriac
syr-SY	syr-SY	dd/MM/yyyy	Syriac (Syria)
ta	ta-IN	(none)	Tamil
ta-IN	ta-IN	dd-MM-yyyy	Tamil (India)
ta-LK	ta-LK	dd-MM-yyyy	Tamil (Sri Lanka)
te	te-IN	(none)	Telugu
te-IN	te-IN	dd-MM-yy	Telugu (India)
tg-Cyrl-TJ	tg-Cyrl-TJ	dd.MM.yyyy	Tajik (Cyrillic) (Tajikistan)
th	th-TH	(none)	Thai
th-TH	th-TH	d/M/yyyy	Thai (Thailand)
ti-ER	ti-ER	d/M/yyyy	Tigrinya (Eritrea)
ti-ET	ti-ET	d/M/yyyy	Tigrinya (Ethiopia)
tk-TM	tk-TM	dd.MM.yy '	y.'Turkmen (Turkmenistan)
tn-BW	tn-BW	dd/MM/yy	Setswana (Botswana)
tn-ZA	tn-ZA	dd/MM/yy	Setswana (South Africa)
tr	tr-TR	(none)	Turkish
tr-TR	tr-TR	dd.MM.yyyy	Turkish (Turkey)
tt	tt-RU	(none)	Tatar
tt-RU	tt-RU	dd.MM.yyyy	Tatar (Russia)
tzm-Latn-DZ	tzm-Latn-DZ	dd-MM-yyyy	Central Atlas Tamazight (Latin) (Algeria)
tzm-Tfng-MA	tzm-Tfng-MA	dd-MM-yyyy	Central Atlas Tamazight (Tifinagh) (Morocco)
ug-CN	ug-CN	yyyy-M-d	Uyghur (China)
uk	uk-UA	(none)	Ukrainian
uk-UA	uk-UA	dd.MM.yyyy	Ukrainian (Ukraine)
ur	ur-PK	(none)	Urdu
ur-PK	ur-PK	dd/MM/yyyy	Urdu (Islamic Republic of Pakistan)
uz	uz-Latn-UZ	(none)	Uzbek
uz-Cyrl-UZ	uz-Cyrl-UZ	dd.MM.yyyy	Uzbek (Cyrillic, Uzbekistan)
uz-Latn-UZ	uz-Latn-UZ	dd/MM yyyy	Uzbek (Latin, Uzbekistan)
vi	vi-VN	(none)	Vietnamese
vi-VN	vi-VN	dd/MM/yyyy	Vietnamese (Vietnam)
wo-SN	wo-SN	dd/MM/yyyy	Wolof (Senegal)
xh-ZA	xh-ZA	yyyy/MM/dd	isiXhosa (South Africa)
yo-NG	yo-NG	dd/MM/yy	Yoruba (Nigeria)
zh-CHS	(none)	(none)	Chinese (Simplified)
zh-CHT	(none)	(none)	Chinese (Traditional)
zh-CN	zh-CN	yyyy/M/d	Chinese (People's Republic of China)
zh-HK	zh-HK	d/M/yyyy	Chinese (Hong Kong S.A.R.)
zh-MO	zh-MO	d/M/yyyy	Chinese (Macao S.A.R.)
zh-SG	zh-SG	d/M/yyyy	Chinese (Singapore)
zh-TW	zh-TW	yyyy/M/d	Chinese (Taiwan)
zu-ZA	zu-ZA	dd-MM-yyyy	isiZulu (South Africa)

 

现在说说有啥用。

SharePoint有个区域设置页面，如果你选择不同的区域，对应的，页面显示的时间类型格式是不同的。上面的表就是让你心里有数，选择什么区域对应什么样的格式。

大部分情况下，这个没什么用。我这里的一个场景是在SharePoint 2010下InfoPath的表单，为了让英国人和美国人能够在日期问题上不产生歧义，将日期全部格式化成了"yyyy-MM-dd"。

en-GB	en-GB	dd/MM/yyyy	English (United Kingdom)
en-US	en-US	M/d/yyyy	English (United States)

这样带来一个问题，SharePoint所有的视图上，为了保持一致，你就需要选择一个恰当的地区。与其一个一个试验，干脆都导出来了。