Netherlands - Formatting standards & code snippets

  1. I18N Standards - Code Snippets
  2. Netherlands

Here is a complete list of standards and formats used in Netherlands. It includes a full list of ISO codes, number, date, currency, telephone and address formats. You will also get code examples on how to perform the most common formatting operations in Java, C#, JavaScript and PHP. Multiple resource files are made available, mainly the complete list of states, in different formats such as CSV, XML, JSON, HTML and SQL.

What are the ISO-3166-1 codes for Netherlands?

  • Alpha-2: NL
  • Alpha-3: NLD
  • Numeric: 528
  • Java Locale Code: nl_NL
  • .Net CultureInfo Code: nl-NL
  • PHP Locale Code: nl_NL

What is the official language in Netherlands?

  • Dutch

What is the date format in Netherlands?

The date format in Netherlands is little-endian:

  • Format: d-M-yyyy
    Ex: 3-12-2014 for December 3rd 2014
Formatting a date in Java:
Locale locale = new Locale("nl", "NL");
SimpleDateFormat sdf = new SimpleDateFormat("d-M-yyyy", locale);
sdf.format(new Date());
Formatting a date in C#:
CultureInfo ci = CultureInfo.GetCultureInfo("nl-NL");
DateTime.Now.ToString("d-M-yyyy", ci);
Formatting a date in JavaScript:
let date = new Date();
date.toLocaleDateString('es-MX');
Formatting a date in PHP:
date("j-n-Y");

What is the time format in Netherlands?

The time format in Netherlands is 24-hour notation in most cases.

  • Format: HH:mm[:ss]
    Ex: 09:00 for 09:00AM, and 21:00 for 09:00PM
Formatting time in Java:
Locale locale = new Locale("nl", "NL");
SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss", locale);
sdf.format(new Date());
Formatting time in C#:
CultureInfo ci = CultureInfo.GetCultureInfo("nl-NL");
DateTime.Now.ToString("HH:mm:ss", ci);
Formatting time in JavaScript:
let time = new Date();
date.toLocaleTimeString('nl-NL');
Formatting time in PHP:
date("H:i:s");

What is the numeric format in Netherlands?

  • Format: 999.999.999,99
    • Group Size: 3
    • Grouping Character: . (dot)
    • Decimal Character: , (comma)
Formatting numbers in Java:
Locale locale = new Locale("nl", "NL");
NumberFormat numberFormat = NumberFormat.getNumberInstance(locale);
numberFormat.format(999999999.99d);
Formatting numbers in C#:
double d = 999999999.99d;
d.ToString("n", CultureInfo.GetCultureInfo("nl-NL")));
Formatting numbers in JavaScript:
let number = 999999999.99;
number.toLocaleString('nl-NL');
Formatting numbers in PHP:
$fmt = new NumberFormatter($locale = 'nl_NL', NumberFormatter::DECIMAL);
$fmt->format(999999999.99);

What is the currency format in Netherlands?

  • Format: € 999.999.999,99
    • Group Size: 3
    • Grouping Character: . (dot)
    • Decimal Character: , (comma)
    • Currency Symbol: €
    • Currency Symbol Position: Before number
    • Currency Name: Euro (EUR)
Formatting currency in Java:
Locale locale = new Locale("nl", "NL");
NumberFormat numberFormat = NumberFormat.getCurrencyInstance(locale);
numberFormat.format(999999999.99d);
Formatting currency in C#:
double d = 999999999.99d;
d.ToString("c", CultureInfo.GetCultureInfo("nl-NL")));
Formatting currency in JavaScript:
let number = 999999999.99;
number.toLocaleString('nl-NL', {currency: 'EUR', style: 'currency'});
Formatting currency in PHP:
$fmt = new NumberFormatter($locale = 'nl_NL', NumberFormatter::CURRENCY);
$fmt->format(999999999.99);

Download list of provinces for Netherlands in CSV, JSON, HTML, SQL and XML

List of provinces: HTML - Select Control

------------------------
 ISO_3166-2 code + name
------------------------
<select>
	<option value="NL-DR">Drenthe</option>
	<option value="NL-FL">Flevoland</option>
	<option value="NL-FR">Fryslân</option>
	<option value="NL-GE">Gelderland</option>
	<option value="NL-GR">Groningen</option>
	<option value="NL-LI">Limburg</option>
	<option value="NL-NB">Noord-Brabant</option>
	<option value="NL-NH">Noord-Holland</option>
	<option value="NL-OV">Overijssel</option>
	<option value="NL-UT">Utrecht</option>
	<option value="NL-ZE">Zeeland</option>
	<option value="NL-ZH">Zuid-Holland</option>
</select>

List of provinces: CSV

code,name
NL-DR,"Drenthe"
NL-FL,"Flevoland"
NL-FR,"Fryslân"
NL-GE,"Gelderland"
NL-GR,"Groningen"
NL-LI,"Limburg"
NL-NB,"Noord-Brabant"
NL-NH,"Noord-Holland"
NL-OV,"Overijssel"
NL-UT,"Utrecht"
NL-ZE,"Zeeland"
NL-ZH,"Zuid-Holland"

List of provinces: JSON

------------------------
 ISO-3166-2 code + Name
------------------------
[
	{code: "NL-DR", name: "Drenthe"}
	{code: "NL-FL", name: "Flevoland"}
	{code: "NL-FR", name: "Fryslân"}
	{code: "NL-GE", name: "Gelderland"}
	{code: "NL-GR", name: "Groningen"}
	{code: "NL-LI", name: "Limburg"}
	{code: "NL-NB", name: "Noord-Brabant"}
	{code: "NL-NH", name: "Noord-Holland"}
	{code: "NL-OV", name: "Overijssel"}
	{code: "NL-UT", name: "Utrecht"}
	{code: "NL-ZE", name: "Zeeland"}
	{code: "NL-ZH", name: "Zuid-Holland"}
]

List of provinces: SQL

-- -----------------------------------------------------
-- Table `province`
-- -----------------------------------------------------
DROP TABLE IF EXISTS province;

CREATE TABLE IF NOT EXISTS province (
  id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  code VARCHAR(6) NOT NULL,
  name VARCHAR(50) NOT NULL
  PRIMARY KEY (id),
  UNIQUE INDEX id_UNIQUE (id ASC),
  UNIQUE INDEX code_UNIQUE (code ASC)
) ENGINE = InnoDB;

INSERT INTO province (id, code, name) VALUES (null, 'NL-DR', 'Drenthe');
INSERT INTO province (id, code, name) VALUES (null, 'NL-FL', 'Flevoland');
INSERT INTO province (id, code, name) VALUES (null, 'NL-FR', 'Fryslân');
INSERT INTO province (id, code, name) VALUES (null, 'NL-GE', 'Gelderland');
INSERT INTO province (id, code, name) VALUES (null, 'NL-GR', 'Groningen');
INSERT INTO province (id, code, name) VALUES (null, 'NL-LI', 'Limburg');
INSERT INTO province (id, code, name) VALUES (null, 'NL-NB', 'Noord-Brabant');
INSERT INTO province (id, code, name) VALUES (null, 'NL-NH', 'Noord-Holland');
INSERT INTO province (id, code, name) VALUES (null, 'NL-OV', 'Overijssel');
INSERT INTO province (id, code, name) VALUES (null, 'NL-UT', 'Utrecht');
INSERT INTO province (id, code, name) VALUES (null, 'NL-ZE', 'Zeeland');
INSERT INTO province (id, code, name) VALUES (null, 'NL-ZH', 'Zuid-Holland');

List of provinces: XML

<!-- ISO 3166-2 code + name -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
	<province>
		<code>NL-DR</code>
		<name>Drenthe</name>
	</province>
	<province>
		<code>NL-FL</code>
		<name>Flevoland</name>
	</province>
	<province>
		<code>NL-FR</code>
		<name>Fryslân</name>
	</province>
	<province>
		<code>NL-GE</code>
		<name>Gelderland</name>
	</province>
	<province>
		<code>NL-GR</code>
		<name>Groningen</name>
	</province>
	<province>
		<code>NL-LI</code>
		<name>Limburg</name>
	</province>
	<province>
		<code>NL-NB</code>
		<name>Noord-Brabant</name>
	</province>
	<province>
		<code>NL-NH</code>
		<name>Noord-Holland</name>
	</province>
	<province>
		<code>NL-OV</code>
		<name>Overijssel</name>
	</province>
	<province>
		<code>NL-UT</code>
		<name>Utrecht</name>
	</province>
	<province>
		<code>NL-ZE</code>
		<name>Zeeland</name>
	</province>
	<province>
		<code>NL-ZH</code>
		<name>Zuid-Holland</name>
	</province>
</provinces>