UNLD DATEFMT

Use this option to override the ULDPARMS +DATEFMT parameter for the current unload statement only. For more information, see DATEFMT.

DATEFMT enables BMC AMI Unload to generate a variety of DATE formats other than the standard Db2 formats.

Specify a string of up to 40 characters as an argument for DATEFMT. BMC AMI Unload replaces character strings to generate the actual date in the formats shown in the following table. All other characters remain unchanged.

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams
DATEFMT 

Date formats

Character string

Date format

YYYY

4-digit year

YY

2-digit year

MM

2-digit month

DD

2-digit day of the month

Example

If today is July 17, 1998, the character string YYYY.MM.DD results in the date format 1998.07.17.

You cannot code more than one instance of a year, day, or month element in a DATEFMT string. For example, the string YYYY/YY/MM/DD is invalid because the year is repeated. 


 

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