iModernize - The Profound Logic Software Blog

SQL Date/Time Formatting Options

Posted by DRusso on Feb 26, 2013 4:23:52 AM

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

Topics: Development, New Features

Subscribe to Blog Updates

....and get The 2019 State of IBM i Modernization survey for FREE!

cover page 2019-1

Recent Posts