National Language Support > Helpful NLS Commands > Setting Date and Time Display and Formatting

Setting Date and Time Display and Formatting

Topics:

You can use SET commands in a procedure to determine how dates will be displayed and formatted in your content. Some of these parameters can be set in the LOCALE settings on the Web Console to apply automatically to any procedures created on the Reporting Server for which these SET parameters are not defined. For more information, see How to Change LOCALE Settings on the WebFOCUS Reporting Server.

DATE_ORDER

This parameter defines the order of date components for display.

The syntax is:

SET DATE_ORDER = {DEFAULT|DMY|MDY|YMD}

where:

DEFAULT

Respects the original order of date components. This is the default value.

DMY

Displays all dates in day/month/year order.

MDY

Displays all dates in month/day/year order.

YMD

Displays all dates in year/month/day order.

Note:

  • DATE_ORDER and DATE_SEPARATOR override the specified date order for all date and date-time displays unless they include a translation display option (T,Tr, t, or tr), in which case the specified order is produced. To limit the scope to a request, use the ON TABLE SET phrase.
  • To use these settings with the Dialogue Manager system variables, (for example, &DATE, &TOD, &YMD, &DATEfmt, and &DATXfmt) append the suffix .DATE_LOCALE to the system variable. This allows system variables that are localized to coexist with non-localized system variables.

DATE_SEPARATOR

This parameter defines the separator for date components for display.

The syntax is:

SET DATE_SEPARATOR = separator

where:

separator

Can be one of the following values.

  • DEFAULT, which respects the separator defined by the USAGE format of the field.
  • SLASH, which uses a slash (/) to separate date components.
  • DASH, which uses a dash (-) to separate date components.
  • BLANK, which uses a blank to separate date components.
  • DOT, which uses a dot (.) to separate date components.
  • NONE, which does not separate date components.

Note:

  • DATE_ORDER and DATE_SEPARATOR override the specified date order for all date and date-time displays unless they include a translation display option (T, Tr, t, or tr), in which case the specified order is produced. To limit the scope to a request, use the ON TABLE SET phrase.
  • To use these settings with the Dialogue Manager system variables, (for example, &DATE, &TOD, &YMD, &DATEfmt, and &DATXfmt) append the suffix .DATE_LOCALE to the system variable. This allows system variables that are localized to coexist with non-localized system variables.

TIME_SEPARATOR

This parameter defines the separator for time components for the &TOD system variable.

The syntax is:

SET TIME_SEPARATOR = {DOT|COLON}

where:

DOT

Uses a dot (.) to separate time components. This is the default value.

COLON

Uses a colon (:) to separate time components.

 WebFOCUS

Feedback