The DATE bind option specifies the format of date output that Db2 returns. If a value is not specified, Db2 uses the value specified in the DATE FORMAT
field on panel DSNTIP4.
| Command option |
Option values |
Used with |
| DATE |
- ( EUR )
- ( ISO )
- ( JIS )
- ( LOCAL )
- ( USA )
|
|
Option descriptions for DATE
- DATE(EUR)
- Use the date format of the IBM® standard for Europe.
- DATE(ISO)
- Use the date format of the International Standards Organization.
- DATE(JIS)
- Use the date format of the Japanese Industrial Standard.
- DATE(LOCAL)
- Use the same date format as specified for the ISO value.
- DATE(USA)
- Use the date format of the IBM standard for the United States of America.
Default values for DATE
| Process |
Default value |
| BIND SERVICE |
The value specified in the DATE FORMAT field of the DSNTIP4 subsystem parameter |