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"] = ".";