UNLD TSFMT

The TIMESTAMP format overrides the standard Db2 TIMESTAMP format with a variety of new formats.

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

Timestamp formats

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams 


Character string

Timestamp format

YYYY

4-digit year.

YY

2-digit year.

MM

2-digit month.

DD

2-digit day of the month.

HH

Current hour, in either a 12-hour or 24-hour format. See XM below.

MI

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).

NN

2-digit number representing hundredths of a second.

NNNN

4-digit number representing tenths of a millisecond.

NNNNNN

6-digit number representing microseconds.

You can set the maximum number of character strings, as follows:

  • Maximum of three NN sets
  • Maximum of one NNNN and one NN
  • Maximum of one NNNNNN

All other characters remain unchanged.

Important

There is no corresponding +TSFMT parameter in the ULDPARMS.



 

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