SQL Date and Time Format and Separator
- David Russo
- Jessica Tomkins
- Rob Ferguson
Owned by David Russo
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.