Page tree
Skip to end of metadata
Go to start of metadata

The following options are provided to control the date/time format and separator used in database-driven components:

  • pui["sql date format"]
  • pui["sql date separator"]
  • pui["sql time format"]
  • pui["sql time separator"]

The option values can be set to any value allowed on the CRTSQLRPGI command for the DATFMT, DATSEP, TIMFMT, AND TIMSEP parameters. The values are not case-sensitive.

If not set, or set to an invalid value, the following defaults will be used:

  • Date format *ISO
  • Time format *ISO

Example:

pui["sql date format"] = "*MDY";
pui["sql date separator"] = "*blank";

pui["sql time format"] = "*hms";
pui["sql time separator"] = ".";

Where do you save this configuration option? Here.

  • No labels