Posted: 11 years 3 months 19 days 13 hours 50 minutes ago
If you are using the green screen SQL interface (STRSQL), then the date format that dates are displayed in can be changed using F13=Services and take option 1=Change session attributes.
Posted: 11 years 3 months 19 days 13 hours 40 minutes ago
okay. never used that feature before, in StrSql. for whatever reason, i expected the display to show the date in the format, defined by the PF.
lives and learns.
thanks.
-sarge
Posted: 11 years 3 months 19 days 13 hours 31 minutes ago
Dates, in RPG, come in as *ISO format regardless of how they are defined in the externally described files. Seeing the date as an *ISO format in debug is correct, typically.
You can modify it by setting the default date format on the File or at the Field-level but most people don't find that feature too intuitive.
I typically use DSPPFM to show the data in the file. However remember, that all interfaces, including SQL extract the date from its 4-byte integer internal format and translate it to the DATFMT specified on the field definition or to the host HLL default date format.
Posted: 11 years 3 months 19 days 10 hours 27 minutes ago
agreed, bob. and i would normally use DSPPFM myself, but the radical in me decided to browse using SQL and got the suspect looking data. silly me for tyring to be innovative...... :)
-sarge