DB2 10.5 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.

You can override the default date and time format in each application interface. To override the default format:

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 rebind db2ubind.lst with the 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
374 Armenia	yyyy-mm-dd	JIS	USA	LOC, USA, EUR, ISO
001 Australia (1)	mm-dd-yyyy	JIS	USA	LOC, USA, EUR, ISO
061 Australia	dd-mm-yyyy	JIS	LOC	LOC, USA, EUR, ISO
043 Austria	dd/mm/yyyy	ISO	ISO	LOC, EUR, ISO
994 Azerbaijan	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
880 Bangladesh	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
375 Belarus	yyyy-mm-dd	ISO	ISO	LOC, 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
855 Cambodia	dd/mm/yyyy	JIS	LOC	LOC, 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
372 Estonia	dd-mm-yyyy	JIS	LOC	LOC, USA, EUR, ISO
251 Ethiopia	dd/mm/yyyy	JIS	LOC	LOC, 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
995 Georgia	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
049 Germany	dd/mm/yyyy	ISO	ISO	LOC, EUR, ISO
030 Greece	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
852 Hong Kong S.A.R. of China	yyyy-mm-dd	JIS	ISO	LOC, USA, 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
062 Indonesia	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
353 Ireland	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
007 Kazakhstan	dd/mm/yyyy	JIS	EUR	LOC, EUR, ISO
254 Kenya	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
082 Korea	mm/dd/yyyy	JIS	ISO	LOC, USA, EUR, ISO
001 Latin America (1)	mm-dd-yyyy	JIS	USA	LOC, USA, EUR, ISO
003 Latin America	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
371 Latvia	yyyy.dd.mm	JIS	LOC	LOC, USA, EUR, ISO
370 Lithuania	yyyy.mm.dd	JIS	LOC	LOC, USA, EUR, ISO
060 Malaysia	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
977 Nepal	yyyy-mm-dd	JIS	ISO	LOC, USA, EUR, ISO
031 Netherlands	dd-mm-yyyy	JIS	ISO	LOC, USA, EUR, ISO
064 New Zealand	dd-mm-yyyy	JIS	LOC	LOC, USA, EUR, ISO
234 Nigeria	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
047 Norway	dd/mm/yyyy	ISO	EUR	LOC, EUR, ISO
092 Pakistan	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
63 Philippines	yyyy-mm-dd	JIS	USA	LOC, USA, 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	EUR	LOC, EUR, ISO
250 Rwanda	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
221 Senegal	dd/mm/yyyy	JIS	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
027 South Africa	mm-dd-yyyy	JIS	USA	LOC, USA, EUR, ISO
034 Spain	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
094 Sri Lanka	dd-mm-yyyy	JIS	ISO	LOC, USA, 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
255 Tanzania	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
066 Thailand (2)	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
090 Turkey	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
256 Uganda	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
380 Ukraine	dd/mm/yyyy	JIS	ISO	LOC, EUR, ISO
044 UK	dd/mm/yyyy	JIS	LOC	LOC, EUR, ISO
001 USA	mm-dd-yyyy	JIS	USA	LOC, USA, EUR, ISO
998 Uzbekistan	yyyy-mm-dd	JIS	LOC	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.