The following is a list of all languages installed with the SQL Server 2017 database engine. This includes the language, along with its associated date formats.
This list can be returned by executing the sp_helplanguage stored procedure, or by querying the sys.syslanguages view directly. The list below contains the column names and their corresponding values for each language.
English
| langid |
0 |
| dateformat |
mdy |
| datefirst |
7 |
| upgrade |
0 |
| name |
us_english |
| alias |
English |
| months |
January, February, March, April, May, June, July, August, September, October, November, December |
| shortmonths |
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec |
| days |
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday |
| lcid |
1033 |
| msglangid |
1033 |
German
| langid |
1 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Deutsch |
| alias |
German |
| months |
Januar, Februar, März, April, Mai, Juni, Juli, August, September, Oktober, November, Dezember |
| shortmonths |
Jan, Feb, Mär, Apr, Mai, Jun, Jul, Aug, Sep, Okt, Nov, Dez |
| days |
Montag, Dienstag, Mittwoch, Donnerstag, Freitag, Samstag, Sonntag |
| lcid |
1031 |
| msglangid |
1031 |
French
| langid |
2 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Français |
| alias |
French |
| months |
janvier, février, mars, avril, mai, juin, juillet, août, septembre, octobre, novembre, décembre |
| shortmonths |
janv, févr, mars, avr, mai, juin, juil, août, sept, oct, nov, déc |
| days |
lundi, mardi, mercredi, jeudi, vendredi, samedi, dimanche |
| lcid |
1036 |
| msglangid |
1036 |
Japanese
| langid |
3 |
| dateformat |
ymd |
| datefirst |
7 |
| upgrade |
0 |
| name |
日本語 |
| alias |
Japanese |
| months |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| shortmonths |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| days |
月曜日, 火曜日, 水曜日, 木曜日, 金曜日, 土曜日, 日曜日 |
| lcid |
1041 |
| msglangid |
1041 |
Danish
| langid |
4 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Dansk |
| alias |
Danish |
| months |
januar, februar, marts, april, maj, juni, juli, august, september, oktober, november, december |
| shortmonths |
jan, feb, mar, apr, maj, jun, jul, aug, sep, okt, nov, dec |
| days |
mandag, tirsdag, onsdag, torsdag, fredag, lørdag, søndag |
| lcid |
1030 |
| msglangid |
1030 |
Spanish
| langid |
5 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Español |
| alias |
Spanish |
| months |
Enero, Febrero, Marzo, Abril, Mayo, Junio, Julio, Agosto, Septiembre, Octubre, Noviembre, Diciembre |
| shortmonths |
Ene, Feb, Mar, Abr, May, Jun, Jul, Ago, Sep, Oct, Nov, Dic |
| days |
Lunes, Martes, Miércoles, Jueves, Viernes, Sábado, Domingo |
| lcid |
3082 |
| msglangid |
3082 |
Italian
| langid |
6 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Italiano |
| alias |
Italian |
| months |
gennaio, febbraio, marzo, aprile, maggio, giugno, luglio, agosto, settembre, ottobre, novembre, dicembre |
| shortmonths |
gen, feb, mar, apr, mag, giu, lug, ago, set, ott, nov, dic |
| days |
lunedì, martedì, mercoledì, giovedì, venerdì, sabato, domenica |
| lcid |
1040 |
| msglangid |
1040 |
Dutch
| langid |
7 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Nederlands |
| alias |
Dutch |
| months |
januari, februari, maart, april, mei, juni, juli, augustus, september, oktober, november, december |
| shortmonths |
jan, feb, mrt, apr, mei, jun, jul, aug, sep, okt, nov, dec |
| days |
maandag, dinsdag, woensdag, donderdag, vrijdag, zaterdag, zondag |
| lcid |
1043 |
| msglangid |
1043 |
Norwegian
| langid |
8 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Norsk |
| alias |
Norwegian |
| months |
januar, februar, mars, april, mai, juni, juli, august, september, oktober, november, desember |
| shortmonths |
jan, feb, mar, apr, mai, jun, jul, aug, sep, okt, nov, des |
| days |
mandag, tirsdag, onsdag, torsdag, fredag, lørdag, søndag |
| lcid |
2068 |
| msglangid |
2068 |
Portuguese
| langid |
9 |
| dateformat |
dmy |
| datefirst |
7 |
| upgrade |
0 |
| name |
Português |
| alias |
Portuguese |
| months |
janeiro, fevereiro, março, abril, maio, junho, julho, agosto, setembro, outubro, novembro, dezembro |
| shortmonths |
jan, fev, mar, abr, mai, jun, jul, ago, set, out, nov, dez |
| days |
segunda-feira, terça-feira, quarta-feira, quinta-feira, sexta-feira, sábado, domingo |
| lcid |
2070 |
| msglangid |
2070 |
Finnish
| langid |
10 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Suomi |
| alias |
Finnish |
| months |
tammikuuta, helmikuuta, maaliskuuta, huhtikuuta, toukokuuta, kesäkuuta, heinäkuuta, elokuuta, syyskuuta, lokakuuta, marraskuuta, joulukuuta |
| shortmonths |
tammi, helmi, maalis, huhti, touko, kesä, heinä, elo, syys, loka, marras, joulu |
| days |
maanantai, tiistai, keskiviikko, torstai, perjantai, lauantai, sunnuntai |
| lcid |
1035 |
| msglangid |
1035 |
Swedish
| langid |
11 |
| dateformat |
ymd |
| datefirst |
1 |
| upgrade |
0 |
| name |
Svenska |
| alias |
Swedish |
| months |
januari, februari, mars, april, maj, juni, juli, augusti, september, oktober, november, december |
| shortmonths |
jan, feb, mar, apr, maj, jun, jul, aug, sep, okt, nov, dec |
| days |
måndag, tisdag, onsdag, torsdag, fredag, lördag, söndag |
| lcid |
1053 |
| msglangid |
1053 |
Czech
| langid |
12 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
čeština |
| alias |
Czech |
| months |
leden, únor, březen, duben, květen, červen, červenec, srpen, září, říjen, listopad, prosinec |
| shortmonths |
I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII |
| days |
pondělí, úterý, středa, čtvrtek, pátek, sobota, neděle |
| lcid |
1029 |
| msglangid |
1029 |
Hungarian
| langid |
13 |
| dateformat |
ymd |
| datefirst |
1 |
| upgrade |
0 |
| name |
magyar |
| alias |
Hungarian |
| months |
január, február, március, április, május, június, július, augusztus, szeptember, október, november, december |
| shortmonths |
jan, febr, márc, ápr, máj, jún, júl, aug, szept, okt, nov, dec |
| days |
hétfő, kedd, szerda, csütörtök, péntek, szombat, vasárnap |
| lcid |
1038 |
| msglangid |
1038 |
Polish
| langid |
14 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
polski |
| alias |
Polish |
| months |
styczeń, luty, marzec, kwiecień, maj, czerwiec, lipiec, sierpień, wrzesień, październik, listopad, grudzień |
| shortmonths |
I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII |
| days |
poniedziałek, wtorek, środa, czwartek, piątek, sobota, niedziela |
| lcid |
1045 |
| msglangid |
1045 |
Romanian
| langid |
15 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
română |
| alias |
Romanian |
| months |
ianuarie, februarie, martie, aprilie, mai, iunie, iulie, august, septembrie, octombrie, noiembrie, decembrie |
| shortmonths |
Ian, Feb, Mar, Apr, Mai, Iun, Iul, Aug, Sep, Oct, Nov, Dec |
| days |
luni, marţi, miercuri, joi, vineri, sîmbătă, duminică |
| lcid |
1048 |
| msglangid |
1048 |
Croatian
| langid |
16 |
| dateformat |
ymd |
| datefirst |
1 |
| upgrade |
0 |
| name |
hrvatski |
| alias |
Croatian |
| months |
siječanj, veljača, ožujak, travanj, svibanj, lipanj, srpanj, kolovoz, rujan, listopad, studeni, prosinac |
| shortmonths |
sij, vel, ožu, tra, svi, lip, srp, kol, ruj, lis, stu, pro |
| days |
ponedjeljak, utorak, srijeda, četvrtak, petak, subota, nedjelja |
| lcid |
1050 |
| msglangid |
1050 |
Slovak
| langid |
17 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
slovenčina |
| alias |
Slovak |
| months |
január, február, marec, apríl, máj, jún, júl, august, september, október, november, december |
| shortmonths |
I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII |
| days |
pondelok, utorok, streda, štvrtok, piatok, sobota, nedeľa |
| lcid |
1051 |
| msglangid |
1051 |
Slovenian
| langid |
18 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
slovenski |
| alias |
Slovenian |
| months |
januar, februar, marec, april, maj, junij, julij, avgust, september, oktober, november, december |
| shortmonths |
jan, feb, mar, apr, maj, jun, jul, avg, sept, okt, nov, dec |
| days |
ponedeljek, torek, sreda, četrtek, petek, sobota, nedelja |
| lcid |
1060 |
| msglangid |
1060 |
Greek
| langid |
19 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
ελληνικά |
| alias |
Greek |
| months |
Ιανουαρίου, Φεβρουαρίου, Μαρτίου, Απριλίου, Μα_ου, Ιουνίου, Ιουλίου, Αυγούστου, Σεπτεμβρίου, Οκτωβρίου, Νοεμβρίου, Δεκεμβρίου |
| shortmonths |
Ιαν, Φεβ, Μαρ, Απρ, Μαϊ, Ιουν, Ιουλ, Αυγ, Σεπ, Οκτ, Νοε, Δεκ |
| days |
Δευτέρα, Τρίτη, Τετάρτη, Πέμπτη, Παρασκευή, Σάββατο, Κυριακή |
| lcid |
1032 |
| msglangid |
1032 |
Bulgarian
| langid |
20 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
български |
| alias |
Bulgarian |
| months |
януари, февруари, март, април, май, юни, юли, август, септември, октомври, ноември, декември |
| shortmonths |
януари, февруари, март, април, май, юни, юли, август, септември, октомври, ноември, декември |
| days |
понеделник, вторник, сряда, четвъртък, петък, събота, неделя |
| lcid |
1026 |
| msglangid |
1026 |
Russian
| langid |
21 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
русский |
| alias |
Russian |
| months |
Январь, Февраль, Март, Апрель, Май, Июнь, Июль, Август, Сентябрь, Октябрь, Ноябрь, Декабрь |
| shortmonths |
янв, фев, мар, апр, май, июн, июл, авг, сен, окт, ноя, дек |
| days |
понедельник, вторник, среда, четверг, пятница, суббота, воскресенье |
| lcid |
1049 |
| msglangid |
1049 |
Turkish
| langid |
22 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Türkçe |
| alias |
Turkish |
| months |
Ocak, Şubat, Mart, Nisan, Mayıs, Haziran, Temmuz, Ağustos, Eylül, Ekim, Kasım, Aralık |
| shortmonths |
Oca, Şub, Mar, Nis, May, Haz, Tem, Ağu, Eyl, Eki, Kas, Ara |
| days |
Pazartesi, Salı, Çarşamba, Perşembe, Cuma, Cumartesi, Pazar |
| lcid |
1055 |
| msglangid |
1055 |
British English
| langid |
23 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
British |
| alias |
British English |
| months |
January, February, March, April, May, June, July, August, September, October, November, December |
| shortmonths |
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec |
| days |
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday |
| lcid |
2057 |
| msglangid |
1033 |
Estonian
| langid |
24 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
eesti |
| alias |
Estonian |
| months |
jaanuar, veebruar, märts, aprill, mai, juuni, juuli, august, september, oktoober, november, detsember |
| shortmonths |
jaan, veebr, märts, apr, mai, juuni, juuli, aug, sept, okt, nov, dets |
| days |
esmaspäev, teisipäev, kolmapäev, neljapäev, reede, laupäev, pühapäev |
| lcid |
1061 |
| msglangid |
1061 |
Latvian
| langid |
25 |
| dateformat |
ymd |
| datefirst |
1 |
| upgrade |
0 |
| name |
latviešu |
| alias |
Latvian |
| months |
janvāris, februāris, marts, aprīlis, maijs, jūnijs, jūlijs, augusts, septembris, oktobris, novembris, decembris |
| shortmonths |
jan, feb, mar, apr, mai, jūn, jūl, aug, sep, okt, nov, dec |
| days |
pirmdiena, otrdiena, trešdiena, ceturtdiena, piektdiena, sestdiena, svētdiena |
| lcid |
1062 |
| msglangid |
1062 |
Lithuanian
| langid |
26 |
| dateformat |
ymd |
| datefirst |
1 |
| upgrade |
0 |
| name |
lietuvių |
| alias |
Lithuanian |
| months |
sausis, vasaris, kovas, balandis, gegužė, birželis, liepa, rugpjūtis, rugsėjis, spalis, lapkritis, gruodis |
| shortmonths |
sau, vas, kov, bal, geg, bir, lie, rgp, rgs, spl, lap, grd |
| days |
pirmadienis, antradienis, trečiadienis, ketvirtadienis, penktadienis, šeštadienis, sekmadienis |
| lcid |
1063 |
| msglangid |
1063 |
Brazilian
| langid |
27 |
| dateformat |
dmy |
| datefirst |
7 |
| upgrade |
0 |
| name |
Português (Brasil) |
| alias |
Brazilian |
| months |
Janeiro, Fevereiro, Março, Abril, Maio, Junho, Julho, Agosto, Setembro, Outubro, Novembro, Dezembro |
| shortmonths |
Jan, Fev, Mar, Abr, Mai, Jun, Jul, Ago, Set, Out, Nov, Dez |
| days |
Segunda-Feira, Terça-Feira, Quarta-Feira, Quinta-Feira, Sexta-Feira, Sábado, Domingo |
| lcid |
1046 |
| msglangid |
1046 |
Traditional Chinese
| langid |
28 |
| dateformat |
ymd |
| datefirst |
7 |
| upgrade |
0 |
| name |
繁體中文 |
| alias |
Traditional Chinese |
| months |
一月, 二月, 三月, 四月, 五月, 六月, 七月, 八月, 九月, 十月, 十一月, 十二月 |
| shortmonths |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| days |
星期一, 星期二, 星期三, 星期四, 星期五, 星期六, 星期日 |
| lcid |
1028 |
| msglangid |
1028 |
Korean
| langid |
29 |
| dateformat |
ymd |
| datefirst |
7 |
| upgrade |
0 |
| name |
한국어 |
| alias |
Korean |
| months |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| shortmonths |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| days |
월요일, 화요일, 수요일, 목요일, 금요일, 토요일, 일요일 |
| lcid |
1042 |
| msglangid |
1042 |
Simplified Chinese
| langid |
30 |
| dateformat |
ymd |
| datefirst |
7 |
| upgrade |
0 |
| name |
简体中文 |
| alias |
Simplified Chinese |
| months |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| shortmonths |
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 |
| days |
星期一, 星期二, 星期三, 星期四, 星期五, 星期六, 星期日 |
| lcid |
2052 |
| msglangid |
2052 |
Arabic
| langid |
31 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
Arabic |
| alias |
Arabic |
| months |
Muharram, Safar, Rabie I, Rabie II, Jumada I, Jumada II, Rajab, Shaaban, Ramadan, Shawwal, Thou Alqadah, Thou Alhajja |
| shortmonths |
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec |
| days |
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday |
| lcid |
1025 |
| msglangid |
1025 |
Thai
| langid |
32 |
| dateformat |
dmy |
| datefirst |
7 |
| upgrade |
0 |
| name |
ไทย |
| alias |
Thai |
| months |
มกราคม, กุมภาพันธ์, มีนาคม, เมษายน, พฤษภาคม, มิถุนายน, กรกฎาคม, สิงหาคม, กันยายน, ตุลาคม, พฤศจิกายน, ธันวาคม |
| shortmonths |
ม.ค., ก.พ., มี.ค., เม.ย., พ.ค., มิ.ย., ก.ค., ส.ค., ก.ย., ต.ค., พ.ย., ธ.ค. |
| days |
จันทร์, อังคาร, พุธ, พฤหัสบดี, ศุกร์, เสาร์, อาทิตย์ |
| lcid |
1054 |
| msglangid |
1054 |
Bokmål
| langid |
33 |
| dateformat |
dmy |
| datefirst |
1 |
| upgrade |
0 |
| name |
norsk (bokmål) |
| alias |
Bokmål |
| months |
januar, februar, mars, april, mai, juni, juli, august, september, oktober, november, desember |
| shortmonths |
jan, feb, mar, apr, mai, jun, jul, aug, sep, okt, nov, des |
| days |
mandag, tirsdag, onsdag, torsdag, fredag, lørdag, søndag |
| lcid |
1044 |
| msglangid |
1044 |