DATE-FORMAT

Changes locally the format in which the date (numeric format with separators) is displayed.

Syntax

DATE-FORMAT {(options}

Option

I International format. Sets the date format locally to International for the duration of the current session (that is, until next logoff/logon). If you omit the I option the date format is set locally to U.S. format.

Operation

Two formats are available:

mm/dd/yyyyU.S. format.

dd/mm/yyyyInternational format.

where:

mm is the number of the month (range 1-12).

ddis the number of the day in the month (range 1-31)

yyyyis the year comprising from zero to four digits, depending on the conversion (default is four digits).

/ represents the non-numeric separator specified with the conversion.

These are dates displayed via forms of the English D conversion that include a separator.

Comments

The date format is reset to that defined in the database config file whenever the database daemon is started up.

Examples

The following command forces the date format at the local port to U.S. (mm/dd/yyyy) for the duration of the current session:

DATE-FORMAT

The following command forces the date format at the local port to International (dd/mm/yyyy) for the duration of the current session:

DATE-FORMAT (I