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.
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
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:
|
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:
where DBNAME is the database name and ISO is the new date format.db2 connect to DBNAME db2 bind @db2ubind.lst datetime ISO blocking all grant public