List of All Languages and Associated Date Formats in SQL Server 2017

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