Netherlands - Formatting standards & code snippets

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 CultireInfo Code: nl-NL
  • PHP Locale Code: nl_NL

What is the official language in Netherlands?

  • Dutch

What is the date format in Netherlands?

The official date format is little-endian, but little-endian is often used:

  • Format: d-M-yyyy
    Ex: 3-12-2014 for December 31st 2014
How to format dates for Netherlands in Java, C#, PHP, and JavaScript

What is the time format in Netherlands?

The time format in Netherlands is mostly 24-hour notation, but 24-hour format is also commonly adopted.

  • HH:mm[:ss]
    Ex: 21:00 for 09:00PM, and 09:00 for 09:00AM
How to format time for Netherlands in Java, C#, PHP, and JavaScript

What is the numeric format in Netherlands?

    Format: 999.999.999,99

  • Group Size: 3
  • Grouping Character: . (Dot)
  • Decimal Character: , (Comma)
How to format numbers for Netherlands in Java, C#, PHP, and JavaScript

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)
How to format currencies for Netherlands in Java, C#, PHP, and JavaScript

Download list of provinces for Netherlands in plain text, 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>