How to translate Substr(Month, 0, 3) to Dutch?

Hi everybody,

I'm using the function Substr(Month, 0, 3) to create a label that refers to the different months of the year:
Jan - Feb - Mar - Apr - May - Jun - Jul - Aug - Sep - Oct - Nov - Dec

I also have a Dutch version of my app where I would like to display the same label, but with their Dutch translations. The letters in bold are the months in which the Dutch version is different:
Jan - Feb - Mrt - Apr - Mei - Jun - Jul - Aug - Sep - Okt - Nov - Dec

Does anyone know how to display the corresponding Dutch abbreviations? It's also a bit tricky when it comes to March, because the Dutch abbreviation for March does not consist of the first 3 letters of the word "Maart" ("March"). The abbreviation translates to "Mrt" (so not "Maa" from "Maart").

Any comments are much appreciated!


I think the best way to do that is use multilingual, check more information here.

Also you can create Static Entity with both translations.

If you use Oracle you can do this query, otherwise (SQL Server) you may need to search for compabilities on query.


select MonthNumber, MonthName,MonthAbr



to_char(add_months(trunc(to_date('2019-12-31', 'YYYY-MM-DD')), -level+1),'mm') as MonthNumber, to_char(add_months(trunc(to_date('2019-12-31', 'YYYY-MM-DD')), -level+1),'Month') as MonthName, to_char(add_months(trunc(to_date('2019-12-31', 'YYYY-MM-DD')), -level+1),'MON') as MonthAbr FROM dual CONNECT BY LEVEL <= (12) ) t order by 1 asc;

Best Regards

Thanks @Igor Khodak 

It helped me a lot too.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.