TIME bind option

The TIME bind option specifies the format of time output that Db2 returns. If a value is not specified, Db2 uses the value specified in the TIME FORMAT field on panel DSNTIP4.

Command option Option values Used with
TIME
  • (EUR)
  • (ISO)
  • (JIS)
  • (LOCAL)
  • (USA)

Option descriptions for TIME

TIME(EUR))
Use the time format of the IBM® standard for Europe.
TIME(ISO)
Use the time format of the International Standards Organization.
TIME(JIS)
Use the time format of the Japanese Industrial Standard.
TIME(LOCAL)
Use the same time format as specified for the ISO value
TIME(USA)
Use the time format of the IBM standard for the United States of America.

Default values for TIME

Process Default value
BIND SERVICE The value specified in the TIME FORMAT field of the DSNTIP4 subsystem parameter