SQL Date and Time Format and Separator

Owned by David Russo
Last updated: Aug 16, 2023 by Jessica Tomkins
1 min read



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.