As you may be aware, Profound UI’s database-driven components can save a lot of work! Using these components, you can build dropdowns, grids, charts, etc., over your DB2 data without having to write any manual code.

One common challenge has been in formatting date and time fields in the result set for these components. All date and time columns display in *ISO format by default. These can be formatted using SQL functions (such as CHAR()), but up to this point, there was no way to control this globally.

With version 4.2.2, new global formatting options have been added:

http://www.profoundlogic.com/docs/display/PUI/SQL+Date+and+Time+Format+and+Separator