Previous Topic Next topic Print topic


FORMAT

Specifies the date and time format when date/time fields are assigned to string representations in host variables. DEF is a date and time format associated with the country code of the database.

Syntax:

FORMAT={DEF | USA | EUR | ISO | JIS | LOC}

Parameters:

EUR is the IBM standard for European date and time format.
ISO is the date and time format of the International Standards Organization.
JIS is the date and time format of the Japanese Industrial Standard.
LOC is the date and time format in local form associated with the country code of the database.
USA is the IBM standard for U.S. date and time format.

Properties:

Default: FORMAT=LOC
Synonym: DATETIME.
Previous Topic Next topic Print topic