Skip to Content

Default language.

UNLD TIMEFMT

Related topics

UNLD syntax option descriptions

UNLD syntax diagrams

ULDPARMS

 

Use this option to override the ULDPARMS parameter for the current unload statement only.

This option enables BMC AMI Unload to generate a variety of time formats other than the standard Db2 formats.

Specify a string of up to 40 characters as an argument for TIMEFMT. BMC AMI Unload replaces character strings to generate the actual time in the formats shown in the following table:

Time formats

Character string

Time format

HH

Current hour, in either 12-hour or 24-hour format.

MM

Minutes elapsed from the top of the hour.

SS

Seconds elapsed from the start of the current minute.

XM

AM or PM, depending on whether the current time is before or after noon.

If XM appears, BMC AMI Unload replaces HH with an hour from a 12-hour clock (00-12); if XM does not appear, BMC AMI Unload replaces HHH with an hour from a 24-hour clock (00-24).

The time element can occur only once, and the entire string must contain at least one time element.

Information
Example

For a time of 3:14 in the afternoon, specifying the format string 'HH-MM(XM)' results in 3-14(PM).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Unload for Db2 13.1