Mar 25, 2012

Month Day and Year Month format of all the cultures in sql server 2012


In Sql server 2012 we can convert any date to Month Day and Year Month format

S.N.
Data
Format
1
Month Day
M or m
2
Year Month
Y or y

SELECT
FORMAT ('2012-03-24 20:42:09.003','M','en-US') AS Month Day,
FORMAT ('2012-03-24 20:42:09.003','Y','en-US') AS Year Month

Or

SELECT
FORMAT ('2012-03-24 20:42:09.003','M') AS Month Day,
FORMAT ('2012-03-24 20:42:09.003','Y') AS Year Month

Output:
umber
Month Day  
Year Month
March 24
   March, 2012

Month Day and Year Month format for date '2012-03-24 20:42:09.003' of all the cultures in sql server 2012

Language
Culture
Month Day
Year Month
a.  Basque
eu
martxoa 24
2012.eko martxoa
Albanian
sq
mars 24
2012-03
Albanian (Albania)
sq-AL
mars 24
2012-03
Alsatian
gsw
24 März
März 2012
Alsatian (France)
gsw-FR
24    März
März 2012
Armenian
hy
24 Մարտ
Մարտ, 2012
Armenian (Armenia)
hy-AM
24 Մարտ
Մարտ, 2012
Ba 2012  Wolof
wo
24 mars
mars 2012
Basque (Basque)
eu-ES
martxoa 24
2012.eko martxoa
Chinese
zh
324
20123
Chinese (Simplified)
zh-Hans
324
20123
Chinese (Simplified) Legacy
zh-CHS
324
20123
Chinese (Simplified, PRC)
zh-CN
324
20123
Chinese (Simplified, Singapore)
zh-SG
324
20123
Chinese (Traditional)
zh-Hant
324
20123
Chinese (Traditional) Legacy
zh-CHT
324
20123
Chinese (Traditional, Hong Kong S.A.R.)
zh-HK
324
20123
Chinese (Traditional, Macao S.A.R.)
zh-MO
324
20123
Chinese (Traditional, Taiwan)
zh-TW
324
20123
Croatian
hr
24. ožujka
ožujak, 2012
Croatian (Croatia)
hr-HR
24. ožujka
ožujak, 2012
Croatian (Latin, Bosnia and Herzegovina)
hr-BA
24. ožujka
ožujak, 2012
Danish
da
24. marts
marts 2012
Danish (Denmark)
da-DK
24. marts
marts 2012
Dari
prs
02 جمادى الأولى
جمادى الأولى, 1433
Dari (Afghanistan)
prs-AF
02 جمادى الأولى
جمادى الأولى, 
Divehi
dv
02 ޖުމާދަލްއޫލާ
ޖުމާދަލްއޫލާ, 1433
Divehi (Maldives)
dv-MV
02 ޖުމާދަލްއޫލާ
ޖުމާދަލްއޫލާ, 1433
Dutch
nl
24 maart
maart 2012
Dutch (Belgium)
nl-BE
24 maart
maart 2012
Dutch (Netherlands)
nl-NL
24 maart
maart 2012
English
en
   March 24

English (Australia)
en-AU
   24 March

English (Canada)
en-CA
March 24
March, 2012
English (India)
en-IN
24 March
March, 2012
English (Ireland)
en-IE
24 March
March 2012
English (Jamaica)
en-JM
March 24
March, 2012
English (Malaysia)
en-MY
24 March
March, 2012
English (New Zealand)
en-NZ
24 March
March 2012
English (Republic of the Philippines)
en-PH
March 24
March, 2012
English (Singapore)
en-SG
24 March
March, 2012
English (South Africa)
en-ZA
24 March
March 2012
English (Trinidad and Tobago)
en-TT
24 March
March 2012
English (United Kingdom)
en-GB
24 March
March 2012
English (United States)
en-US
March 24
March, 2012
English (Zimbabwe)
en-ZW
March 24
March, 2012
Estonian
et
24. märts
märts 2012. a.
Estonian (Estonia)
et-EE
24.    märts
märts 2012. 
Faroese (Faroe Islands)
fo-FO
24. mars
mars 2012
Finnish
fi
24. maaliskuuta
maaliskuu 2012
Finnish (Finland)
fi-FI
24.    maaliskuuta

French
fr
24 mars
mars 2012
French (Belgium)
fr-BE
24    mars
mars 2012
French (Canada)
fr-CA
24 mars
mars, 2012
French (France)
fr-FR
24 mars
mars 2012
French (Luxembourg)
fr-LU
24    mars
mars 2012
French (Monaco)
fr-MC
24 mars
mars 2012
French (Switzerland)
fr-CH
24    mars
mars 2012
Frisian
fy
24 maart
maart 2012
Frisian (Netherlands)
fy-NL
24 maart
maart 2012
Galician
gl
24 marzo
marzo de 2012
Galician (Galician)
gl-ES
24 marzo
marzo de 2012
Georgian
ka
24 03
მარტი 2012
Georgian (Georgia)
ka-GE
24 03
მარტი 2012
German
de
24 März
März 2012
German (Austria)
de-AT
24    März
März 2012
German (Germany)
de-DE
24    März
März 2012
German (Liechtenstein)
de-LI
24    März
März 2012
German (Luxembourg)
de-LU
24    März
März 2012
German (Switzerland)
de-CH
24    März
März 2012
Greek
el
   24 Μαρτίου

Greenlandic
kl
24. martsi
martsi 2012
Greenlandic (Greenland)
kl-GL
24. martsi
martsi 2012
Gujarati
gu
24 માર્ચ
માર્ચ, 2012
Gujarati (India)
gu-IN
24 માર્ચ
માર્ચ, 2012
Hausa
ha
Maris    24

Hausa (Latin, Nigeria)
ha-Latn-NG
Maris 24
Maris, 2012
Hebrew
he
24 מרץ
מרץ 2012
Hebrew (Israel)
he-IL
24 מרץ
מרץ 2012
Hindi
hi
24 मार्च
मार्च, 2012
Hindi (India)
hi-IN
24 मार्च
मार्च, 2012
Hungarian
hu
március 24.
2012. március
Hungarian (Hungary)
hu-HU
március 24.
2012. március
Icelandic
is
24. mars
mars 2012
Icelandic (Iceland)
is-IS
24. mars
mars 2012
Igbo
ig
Onwa ato 24
Onwa ato, 2012
Igbo (Nigeria)
ig-NG
Onwa ato 24
Onwa ato, 2012
Indonesian
id
24 Maret
Maret 2012
Indonesian (Indonesia)
id-ID
24 Maret
Maret 2012
Inuktitut
iu
Maatsi 24
Maatsi, 2012
Inuktitut (Latin)
iu-Latn
   Maatsi 24

Inuktitut (Syllabics)
iu-Cans
ᒫᑦᓯ 24
ᒫᑦᓯ,2012
Inuktitut (Syllabics, Canada)
iu-Cans-CA
ᒫᑦᓯ 24
ᒫᑦᓯ,2012
Irish
ga
24 Márta
Márta 2012
Irish (Ireland)
ga-IE
24 Márta
Márta 2012
isiXhosa
xh
24 Kwindla
Kwindla 2012
isiXhosa (South Africa)
xh-ZA
24 Kwindla
Kwindla 2012
isiZulu
zu
24 uNdasa
uNdasa 2012
isiZulu (South Africa)
zu-ZA
24 uNdasa
uNdasa 2012
Italian
it
24 marzo
marzo 2012
Italian (Italy)
it-IT
25 marzo
marzo 2012
Italian (Switzerland)
it-CH
24.    marzo
marzo 
Japanese
ja
324
20123
Japanese (Japan)
ja-JP
324
20123
Kannada
kn
24 ಮಾರ್ಚ್
ಮಾರ್ಚ್, 2012
Kannada (India)
kn-IN
24 ಮಾರ್ಚ್
ಮಾರ್ಚ್, 2012
Kazakh
kk
24 наурыз
наурыз 2012
Kazakh (Kazakhstan)
kk-KZ
24 наурыз
наурыз 2012
Khmer
km
ថ្ងៃទី 24 ខែ 03
ខែ 03 ឆ្នាំ 2012
Khmer (Cambodia)
km-KH
ថ្ងៃទី 24 ខែ 03
ខែ 03 ឆ្នាំ 2012
K'iche
qut
24 rox ik'
rox ik' de 2012
K'iche (Guatemala)
qut-GT
24 rox ik'
rox ik' de 2012
Kinyarwanda
rw
Werurwe 24
Werurwe, 2012
Kinyarwanda (Rwanda)
rw-RW
Werurwe 24
Werurwe, 2012
Kiswahili
sw
Machi 24
Machi, 2012
Kiswahili (Kenya)
sw-KE
Machi 24
Machi, 2012
Konkani
kok
24 मार्च
मार्च, 2012
Konkani (India)
kok-IN
24 मार्च
मार्च, 2012
Korean
ko
3 24
2012 3
Korean (Korea)
ko-KR
3 24
2012 3
Kyrgyz
ky
24 Март
Март 2012-ж.
Kyrgyz (Kyrgyzstan)
ky-KG
24 Март
Март 2012-ж.
Language
Culture
Month Day(M)
Year Month(Y)
Lao
lo
24 ມີນາ
ມີນາ 2012
Lao (Lao P.D.R.)
lo-LA
24 ມີນາ
ມີນາ 2012
Latvian
lv
24. martā
2012. marts
Latvian (Latvia)
lv-LV
24. martā
2012. marts
Lithuanian
lt
kovo 24 d.
2012 m. kovas
Lithuanian (Lithuania)
lt-LT
kovo    24 d.
2012 m. kovas
Lower Sorbian
dsb
24. měrca
měrc 2012
Lower Sorbian (Germany)
dsb-DE
24. měrca
měrc 2012
Luxembourgish
lb
24    Mäerz
Mäerz 2012
Luxembourgish (Luxembourg)
lb-LU
24 Mäerz
Mäerz 2012
maaliskuu 2012  Filipino
fil
Marso    24

Maatsi, 2012  Inuktitut (Latin, Canada)
iu-Latn-CA
Maatsi 24
Maatsi, 2012
Macedonian (Former Yugoslav Republic of Macedonia)
mk-MK
24 март
март 2012
Macedonian (FYROM)
mk
24    март
март 2012
Maghres, 2012  Uyghur
ug
3-ئاي 24-كۈنى
2012-يىلى 3-
Malay
ms
24 Mac
Mac 2012
Malay (Brunei Darussalam)
ms-BN
24 Mac
Mac 2012
Malay (Malaysia)
ms-MY
24 Mac
Mac 2012
Malayalam
ml
24 മാറ്ച്ച്
മാറ്ച്ച്, 2012
Malayalam (India)
ml-IN
24 മാറ്ച്ച്
മാറ്ച്ച്, 2012
Maltese
mt
   24 ta' Marzu

Maori
mi
24 Poutū-te-rangi
Poutū-te-rangi, 12
Maori (New Zealand)
mi-NZ
24 Poutū-te-rangi
Poutū-te-rangi, 12
Marathi
mr
24 मार्च
मार्च, 2012
Marathi (India)
mr-IN
24 मार्च
मार्च, 2012
March 2012  English (Belize)
en-BZ
24 March
March 2012
March, 2012  English (Caribbean)
en-029
March 24
March, 2012
Maris, 2012  Hausa (Latin)
ha-Latn
Maris 24
Maris, 2012
Marso, 2012  Faroese
fo
24. mars
mars 2012
Marso, 2012  Filipino (Philippines)
fil-PH
   Marso 24

marzo de 2012  Spanish (Argentina)
es-AR
24 marzo
marzo de 2012
marzo de 2012  Spanish (Uruguay)
es-UY
24 marzo
marzo de 2012
Marzu 2012  Maltese (Malta)
mt-MT
24 ta' Marzu
Marzu 2012
Mohawk
moh
   Enniskó:Wa 24
Enniskó:Wa, 2012
Mohawk (Mohawk)
moh-CA
Enniskó:Wa 24
Enniskó:Wa, 2012
Mongolian
mn
   24 3 дугаар сарын
2012 он 3 дугаар сар
Mongolian (Cyrillic)
mn-Cyrl
24 3 дугаар сарын
2012 он 3 дугаар сар
Mongolian (Cyrillic, Mongolia)
mn-MN
24 3 дугаар сарын
2012 он 3 дугаар сар
Mongolian (Traditional Mongolian)
mn-Mong
3ᠰᠠᠷ᠎ᠠ    24ᠡᠳᠦᠷ
2012ᠣᠨ 3ᠰᠠᠷ᠎ᠠ
Mongolian (Traditional Mongolian, PRC)
mn-Mong-CN
   3ᠰᠠᠷ᠎ᠠ 24ᠡᠳᠦᠷ
2012ᠣᠨ 3ᠰᠠᠷ᠎ᠠ
Mopitlo 2012  Occitan
oc
24 de març
març 2012
Mopitloe 2012  Turkish
tr
24 Mart
Mart 2012
Nepali
ne
मार्च 24
मार्च,2012
Nepali (Nepal)
ne-NP
मार्च 24
मार्च,2012
njoktje 2012  Sami (Lule)
smj
   sjnjuktjamáno 24. b.
sjnjuktjamánno 2012
njoktje 2012  Sami, Southern (Sweden)
sma-SE
   njoktjen 24. b.

Norwegian
no
24. mars
mars 2012
Norwegian (Bokmsl)
nb
24. mars
mars 2012
Norwegian (Nynorsk)
nn
24. mars
mars 2012
Norwegian, Bokmsl (Norway)
nb-NO
24. mars
mars 2012
Norwegian, Nynorsk (Norway)
nn-NO
24. mars
mars 2012
Occitan (France)
oc-FR
24 de març
març 2012
Oriya
or
24 ମାର୍ଚ୍ଚ
ମାର୍ଚ୍ଚ, 2012
Oriya (India)
or-IN
24 ମାର୍ଚ୍ଚ
ମାର୍ଚ୍ଚ, 2012
Pashto
ps
03 جمادى الأولى
جمادى الأولى, 1433
Pashto (Afghanistan)
ps-AF
02 جمادى الأولى
جمادى الأولى, 
Persian
fa
مارس 24
مارس, 2012
Persian
fa-IR
مارس 24
مارس, 2012
Polish
pl
24 marca
marzec 2012
Polish (Poland)
pl-PL
24 marca
marzec 2012
Portuguese
pt
25 de março
março de 2012
Portuguese (Brazil)
pt-BR
24 de março
março de 2012
Portuguese (Portugal)
pt-PT
24-3
Março de 2012
Punjabi
pa
24 ਮਾਰਚ
ਮਾਰਚ, 2012
Punjabi (India)
pa-IN
24 ਮਾਰਚ
ਮਾਰਚ, 2012
Quechua
quz
Pauqar waray 24
Pauqar waray de 2012
Quechua (Bolivia)
quz-BO
Pauqar waray 24
Pauqar waray de 2012
Quechua (Ecuador)
quz-EC
Pauqar waray 24
Pauqar waray de 2012
Quechua (Peru)
quz-PE
Pauqar waray 24
Pauqar waray de 2012
Romanian
ro
24 martie
martie 2012
Romanian (Romania)
ro-RO
24 martie
martie 2012
Romansh
rm
24 mars
mars 2012
Romansh (Switzerland)
rm-CH
24    mars
mars 2012
Russian
ru
марта 24
Март 2012
Russian (Russia)
ru-RU
марта 24
Март 2012
Sami (Inari)
smn
njuhčâmáánu    24. p.
njuhčâmáánu 
Sami (Northern)
se
njukčamánu    24. b.
njukčamánnu 
Sami (Skolt)
sms
   pâ´zzlâšttammannu 24. p.
pâ´zzlâšttammään 2012
Sami (Southern)
sma
njoktjen 24.    b.
njoktje 2012
Sami, Inari (Finland)
smn-FI
njuhčâmáánu 25. p.
njuhčâmáánu 2012
Sami, Lule (Norway)
smj-NO
sjnjuktjamáno 24. b.
sjnjuktjamánno 2012
Sami, Lule (Sweden)
smj-SE
sjnjuktjamáno 24. b.
sjnjuktjamánno 2012
Sami, Northern (Finland)
se-FI
njukčamánu 25. b.
njukčamánnu 2012
Sami, Northern (Norway)
se-NO
   njukčamánu 24. b.
njukčamánnu 2012
Sami, Northern (Sweden)
se-SE
   njukčamánu 24. b.
njukčamánnu 2012
Sami, Skolt (Finland)
sms-FI
pâ´zzlâšttammannu 24. p.
pâ´zzlâšttammään 2012
Sami, Southern (Norway)
sma-NO
   njoktjen 24. b.

Sanskrit
sa
24 मार्च
मार्च, 2012
Sanskrit (India)
sa-IN
25 मार्च
मार्च, 2012
Scottish Gaelic
gd
24 Am Màrt
Am Màrt 2012
Scottish Gaelic (United Kingdom)
gd-GB
24 Am    Màrt
Am Màrt 2012
Serbian
sr
24. mart
mart 2012
Serbian (Cyrillic)
sr-Cyrl
24. март
март 2012
Serbian (Cyrillic, Bosnia and Herzegovina)
sr-Cyrl-BA
24.    март
март, 2012
Serbian (Cyrillic, Montenegro)
sr-Cyrl-ME
24. март
март 2012
Serbian (Cyrillic, Serbia and Montenegro (Former))
sr-Cyrl-CS
   24. март
март 2012
Serbian (Cyrillic, Serbia)
sr-Cyrl-RS
24. март
март 2012
Serbian (Latin)
sr-Latn
24. mart
mart 2012
Serbian (Latin, Bosnia and Herzegovina)
sr-Latn-BA
24. mart
mart 2012
Serbian (Latin, Montenegro)
sr-Latn-ME
24. mart
mart 2012
Serbian (Latin, Serbia and Montenegro (Former))
sr-Latn-CS
24.    mart
mart 2012
Serbian (Latin, Serbia)
sr-Latn-RS
24. mart
mart 2012
Sesotho sa Leboa
nso
24 Mopitlo
Mopitlo 2012
Sesotho sa Leboa (South Africa)
nso-ZA
24    Mopitlo

Setswana
tn
24 Mopitloe
Mopitloe 2012
Setswana (South Africa)
tn-ZA
24    Mopitloe

Sinhala
si
මාර්තු 24
2012 මාර්තු
Sinhala (Sri Lanka)
si-LK
මාර්තු 24
2012 මාර්තු
Slovak
sk
24 marca
marec 2012
Slovak (Slovakia)
sk-SK
24 marca
marec 2012
Slovenian
sl
24. marec
marec 2012
Slovenian (Slovenia)
sl-SI
24. marec
marec 2012
Spanish
es
   24 marzo

Spanish (Bolivarian Republic of Venezuela)
es-VE
24 marzo
marzo de 2012
Spanish (Bolivia)
es-BO
24 marzo
marzo de 2012
Spanish (Chile)
es-CL
24 marzo
marzo de 2012
Spanish (Colombia)
es-CO
24 marzo
marzo de 2012
Spanish (Costa Rica)
es-CR
24 marzo
marzo de 2012
Spanish (Dominican Republic)
es-DO
24 marzo
marzo de 2012
Spanish (Ecuador)
es-EC
24 marzo
marzo de 2012
Spanish (El Salvador)
es-SV
24 marzo
marzo de 2012
Spanish (Guatemala)
es-GT
24 marzo
marzo de 2012
Spanish (Honduras)
es-HN
24 marzo
marzo de 2012
Spanish (Mexico)
es-MX
24 marzo
marzo de 2012
Spanish (Nicaragua)
es-NI
24 marzo
marzo de 2012
Spanish (Panama)
es-PA
24 marzo
marzo de 2012
Spanish (Paraguay)
es-PY
24 marzo
marzo de 2012
Spanish (Peru)
es-PE
24 marzo
marzo de 2012
Spanish (Puerto Rico)
es-PR
24 marzo
marzo de 2012
Spanish (Spain, International Sort)
es-ES
24 marzo
marzo de 2012
Spanish (United States)
es-US
   24 de marzo

Swedish
sv
den 24 mars
mars 2012
Swedish (Finland)
sv-FI
den 24 mars
mars 2012
Swedish (Sweden)
sv-SE
den 24 mars
mars 2012
Syriac
syr
24 ܐܕܪ
ܐܕܪ, 2012
Syriac (Syria)
syr-SY
24 ܐܕܪ
ܐܕܪ, 2012
Tajik
tg
марти 24
Март 2012
Tajik (Cyrillic)
tg-Cyrl
марти 24
Март 2012
Tajik (Cyrillic, Tajikistan)
tg-Cyrl-TJ
марти 24
Март 2012
Tamazight
tzm
24 Maghres
Maghres, 2012
Tamazight (Latin)
tzm-Latn
24    Maghres
Maghres, 2012
Tamazight (Latin, Algeria)
tzm-Latn-DZ
   24 Maghres

Tamil
ta
24 மார்ச்
மார்ச் 2012
Tamil (India)
ta-IN
24 மார்ச்
மார்ச் 2012
Tatar
tt
24 Мартның
Март 2012
Tatar (Russia)
tt-RU
24 Мартның
Март 2012
Telugu
te
24 మార్చి
మార్చి, 2012
Telugu (India)
te-IN
24 మార్చి
మార్చి, 2012
Thai
th
24 มีนาคม
มีนาคม 2555
Thai (Thailand)
th-TH
24 มีนาคม
มีนาคม 2555
Turkish (Turkey)
tr-TR
24    Mart
Mart 2012
Turkmen
tk
Mart 24
2012 ý. Mart
Turkmen (Turkmenistan)
tk-TM
Mart 24
2012 ý. Mart
Ukrainian (Ukraine)
uk-UA
24    березня
Березень 2012 
Upper Sorbian
hsb
24. měrca
měrc 2012
Upper Sorbian (Germany)
hsb-DE
24. měrca
měrc 2012
Urdu (Islamic Republic of Pakistan)
ur-PK
24    مارچ
مارچ, 2012
Uzbek
uz
24-mart
mart 2012
Uzbek (Cyrillic)
uz-Cyrl
24-март
Март 2012
Uzbek (Cyrillic, Uzbekistan)
uz-Cyrl-UZ
   24-март
Март 2012
Uzbek (Latin)
uz-Latn
24-mart
mart 2012
Uzbek (Latin, Uzbekistan)
uz-Latn-UZ
   24-mart
mart 2012
Vietnamese
vi
24 Tháng Ba
Tháng Ba 2012
Vietnamese (Vietnam)
vi-VN
24    Tháng Ba
Tháng 
Welsh
cy
24 Mawrth
Mawrth 2012
Welsh (United Kingdom)
cy-GB
24 Mawrth
Mawrth 2012
Wolof (Senegal)
wo-SN
24 mars
mars 2012
Yakut
sah
кулун тутар 24
Кулун тутар 2012 с.
Yakut (Russia)
sah-RU
кулун тутар    24
Кулун тутар 
Yi
ii
3 24
2012 3
Yi (PRC)
ii-CN
3 24
2012 3
Yoruba
yo
   Osu keta 24
Osu keta, 2012
Yoruba (Nigeria)
yo-NG
Osu keta 24
Osu keta, 2012
Μάρτιος 2012  Greek (Greece)
el-GR
24 Μαρτίου
Μάρτιος 2012
р.  Urdu
ur
24 مارچ
مارچ, 2012
ئاي  Uyghur (PRC)
ug-CN
3-ئاي    24-كۈنى
2012

No comments:

Post a Comment