DB2 Version 9.7 for Linux, UNIX, and Windows

Date and time formats by territory code

The character string representation of date and time formats is the default format of datetime values associated with the client territory code of the application. This default format can be overridden and each application interface has a different way to do so. For example:

CLI/ODBC applications use the DateTimeStringFormat configuration keyword
JDBC applications use the dateFormat or timeFormat property
Embedded applications use the PRECOMPILE or BIND command
DB2® utilities require rebinding db2ubind.lst with DATETIME format option

Table 1. Territory code descriptions
Territory Code	Description
DEF	Default territory code
EUR	IBM® standard for Europe
ISO	International Standards Organization
JIS	Japanese Industrial Standard
LOC	Local form associated with the territory code of the database
USA	IBM standard for the United States

Following is a description of the input and output formats for date and time:

Input Time Format
- There is no default input time format
- All time formats are allowed as input for all territory codes.
Output Time Format
- The default output time format is equal to the local time format.
Input Date Format
- There is no default input date format
- Where the local format for date conflicts with an ISO, JIS, EUR, or USA date format, the local format is recognized for date input. For example, see the UK entry in Table 2.
Output Date Format
- The default output date format is shown in Table 2.
  Note: Table 2 also shows a listing of the string formats for the various territory codes.

Table 2. Date and Time Formats by Territory Code
Client Territory Code	Local Date Format	Local Time Format	Default Output Date Format	Input Date Formats
355 Albania	yyyy-mm-dd	JIS	LOC	LOC, USA, EUR, ISO
785 Arabic	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
001 Australia (1)	mm-dd-yyyy	JIS	LOC	LOC, USA, EUR, ISO
061 Australia	dd-mm-yyyy	JIS	LOC	LOC, USA, EUR, ISO
994 Azerbaijan	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
032 Belgium	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
055 Brazil	dd.mm.yyyy	JIS	LOC	LOC, EUR, ISO
359 Bulgaria	dd.mm.yyyy	JIS	EUR	LOC, USA, EUR, ISO
001 Canada	mm-dd-yyyy	JIS	USA	LOC, USA, EUR, ISO
002 Canada (French)	dd-mm-yyyy	ISO	ISO	LOC, USA, EUR, ISO
086 China	mm/dd/yyyy	JIS	ISO	LOC, USA, EUR, ISO
385 Croatia	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
042 Czech Republic	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
045 Denmark	dd-mm-yyyy	ISO	ISO	LOC, USA, EUR, ISO
358 Finland	dd/mm/yyyy	ISO	EUR	LOC, EUR, ISO
389 FYR Macedonia	dd.mm.yyyy	JIS	EUR	LOC, USA, EUR, ISO
033 France	dd/mm/yyyy	JIS	EUR	LOC, EUR, ISO
049 Germany	dd/mm/yyyy	ISO	ISO	LOC, EUR, ISO
030 Greece	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
036 Hungary	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
354 Iceland	dd-mm-yyyy	JIS	LOC	LOC, USA, EUR, ISO
091 India	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
972 Israel	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
039 Italy	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
081 Japan	mm/dd/yyyy	JIS	ISO	LOC, USA, EUR, ISO
082 Korea	mm/dd/yyyy	JIS	ISO	LOC, USA, EUR, ISO
001 Latin America (1)	mm-dd-yyyy	JIS	LOC	LOC, USA, EUR, ISO
003 Latin America	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
356 Malta	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
382 Montenegro	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
031 Netherlands	dd-mm-yyyy	JIS	LOC	LOC, USA, EUR, ISO
047 Norway	dd/mm/yyyy	ISO	EUR	LOC, EUR, ISO
092 Pakistan	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
048 Poland	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
351 Portugal	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
040 Romania	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
007 Russia	dd/mm/yyyy	ISO	LOC	LOC, EUR, ISO
381 Serbia	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
042 Slovakia	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
386 Slovenia	dd.mm.yyyy	JIS	EUR	LOC, USA, EUR, ISO
034 Spain	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
046 Sweden	dd/mm/yyyy	ISO	ISO	LOC, EUR, ISO
041 Switzerland	dd/mm/yyyy	ISO	EUR	LOC, EUR, ISO
088 Taiwan	mm-dd-yyyy	JIS	ISO	LOC, USA, EUR, ISO
066 Thailand (2)	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
090 Turkey	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
044 UK	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
001 USA	mm-dd-yyyy	JIS	USA	LOC, USA, EUR, ISO
084 Vietnam	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
Note: Countries/Regions using the default C locale are assigned territory code 001. yyyy in Buddhist era is equivalent to Gregorian + 543 years (Thailand only).

Example

You can use the command line to change the default date format to ISO (YYYY-MM-DD) by doing the following:

Change your current directory to sqllib\bnd.
- For Windows operating systems, change the directory to c:\program files\IBM\sqllib\bnd.
- For UNIX operating systems, change the directory to /home/db2inst1/sqllib/bnd.
Connect to the database from the operating system shell using the SYSADM authority:
```
db2 connect to DBNAME
db2 bind @db2ubind.lst datetime ISO blocking all grant public
```
where DBNAME is the database name and ISO is the new date format.