TIMEFMT

The TIMEFMT option allows you to override the default Db2 external time format.

This option also overrides your Db2 time exit routine and the ULDPARMS TIMEFMT parameter. This option is useful for porting unloaded data to other relational databases.

'string'

This option allows you to specify a string of time format elements. Valid values are: HH for hour MM for minute SS for second XM for AM or PM You can specify these values in any order and delimit them with any character or number, or any series of characters or numbers, although BMC AMI Unload does not require a delimiter. Warning Example For a time of 3:14 in the afternoon, specifying the format string 'HH-MM(XM)' results in 3-14(PM).

Requirements

The following requirements apply to the string that you specify with the TIMEFMT option:

• The string must begin with one of the valid time format elements.
• Only one occurrence of each value is valid.
• If you specify this option, you must specify at least one value or the unload job terminates.

Additional considerations

The following considerations apply to this option:

• If you specify XM, BMC AMI Unload converts the HH element to a 12-hour format.
• BMC AMI Unloadtreats any other characters as constants in their specified position.