Globalization

Valid Day Values of Week for Different NLS_DATE_LANGUAGE

In this post, I listed valid day values of some NLS_DATE_LANGUAGE other than AMERICAN and ENGLISH for you as a reference in order to solve ORA-01846: not a valid day of the week in SQL statements with TO_DATE function.

As for valid values of week days, you may check: Valid Month Values for Different NLS_DATE_LANGUAGE.

Please not that, the first day of a week (1-7) may vary from territory to territory. For instance, in AMERICA territory, the first day of week is SUNDAY. For Islamic countries, the first day of week is Saturday.

For complete language to territory mapping in Oracle, you may check: NLS_LANGUAGE to NLS_TERRITORY Mapping Table.

If you like to know more valid day values on languages other than the above listed, please leave you message in the comment.

Europe Languages

FRENCH (NLS_TERRITORY=FRANCE)

DDAYDY
1LundiLUN.
2MardiMAR.
3MercrediMER.
4JeudiJEU.
5VendrediVEN.
6SamediSAM.
7DimancheDIM.

GERMAN (NLS_TERRITORY=GERMANY)

DDAYDY
1MontagMO
2DienstagDI
3MittwochMI
4DonnerstagDO
5FreitagFR
6SamstagSA
7SonntagSO

ITALIAN (NLS_TERRITORY=ITALY)

DDAYDY
1LunedìLUN
2MartedìMAR
3MercoledìMER
4GiovedìGIO
5VenerdìVEN
6SabatoSAB
7DomenicaDOM

SPANISH (NLS_TERRITORY=SPAIN)

DDAYDY
1LunesLUN
2MartesMAR
3MiércolesMIÉ
4JuevesJUE
5ViernesVIE
6SábadoSÁB
7DomingoDOM

Asia Languages

JAPANESE (NLS_TERRITORY=JAPAN)

DDAYDY
1日曜日
2月曜日
3火曜日
4水曜日
5木曜日
6金曜日
7土曜日

KOREAN (NLS_TERRITORY=KOREA)

DDAYDY
1일요일
2월요일
3화요일
4수요일
5목요일
6금요일
7토요일

SIMPLIFIED CHINESE (NLS_TERRITORY=CHINA)

DDAYDY
1星期日星期日
2星期一星期一
3星期二星期二
4星期三星期三
5星期四星期四
6星期五星期五
7星期六星期六

TRADITIONAL CHINESE (NLS_TERRITORY=TAIWAN)

DDAYDY
1星期日星期日
2星期一星期一
3星期二星期二
4星期三星期三
5星期四星期四
6星期五星期五
7星期六星期六

Leave a Reply

Your email address will not be published. Required fields are marked *