Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Unload for Db2 13.1.

+DATEFMT

Use this parameter to set or override the default date format. BMC AMI Unload default date format when running DIRECT YES.  If running DIRECT NO and you want to change the Db2 default date format use the DATEFMT keyword on the UNLOAD statement.

The distributed default is DECP. This default affects only the external representation of date values when using any format other than UNLOAD. The DATEFMT unload keyword overrides this parameter.

DATEFMT.png

Operands

ISO

(SPE2010) (Default) Uses the ISO date format (yyyy-mm-dd)

EUR

Uses the European date format (dd.mm.yyyy)

JIS

Uses the Japanese Industrial Standard date format (yyyy-mm-dd)

USA

Uses the USA date format (mm/dd/yyyy)

DECP

Uses the standard date format as defined in DSNHDECP

Information
Example
+DATEFMT(EUR)

BMC AMI Unload sets the default format to European:

Warning

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

Related topic

BMC-AMI-Unload-parameters-ULDPARMS-DD 


 

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

BMC AMI Unload for Db2 12.1