DATE FORMAT field (DATE DECP value)
The DATE DECP value controls the default format that is to be used to represent dates in output.
| Acceptable values: | ISO, USA, EUR, JIS, LOCAL |
|---|---|
| Default: | ISO |
| Update: | not recommended |
| dsnhdecp: | DATE |
The date formats that are associated with the acceptable values for this field are shown in the following table.
Date formats
| Format name | Abbreviation | Format | Example |
|---|---|---|---|
| International Standards Organization | ISO | yyyy-mm-dd | 2003-12-23 |
| IBM® USA standard | USA | mm/dd/yyyy | 12/23/2003 |
| IBM European standard | EUR | dd.mm.yyyy | 23.12.2003 |
| Japanese Industrial Standard Christian Era | JIS | yyyy-mm-dd | 2003-12-23 |
| Locally defined (by an installation exit routine) | LOCAL | your choice |
Db2 accepts dates in any format as input. Db2 interprets the input date based on the punctuation, and then provides date output in the format that you specify for this parameter. If you use LOCAL, you must provide a date exit routine to perform date formatting.