Re: TO_CHAR function

On 26-Mar-2015 11:31 -0500, Gary Thompson wrote:

iSeries at V7R1, about a year behind on PTF's

I'm using the TO_CHAR SQL function to output time-stamp info in a
'user-friendly' format.

In one document I found discussing this function, I see the comment:
"AM is the default meridian indicator."

So-far, I've not been able to create a TO_CHAR format string on our
iSeries that returns a time with an AM/PM "indicator" - so I think I
need to use a CASE statement ?

What format-string was specified [and of course was expected to function as desired], and what were the unexpected results? Was perhaps the following string attempted, and with what results?:

TO_CHAR(myTimeStampColumn,'DD-Mon-YYYY HH24:MI AM')

Might the CHAR function suffice, using the value USA as the second argument for the TIME-value specified as the datetime-expression for the first argument, concatenated to the end of the VARCHAR_FORMAT using a format-string that does not include the TIME portion [that fails to format properly], to serve as a circumvention pending resolution to the difficulty? Perhaps:

TO_CHAR(myTimeStampColumn,'Day DD Mon YYYY ')
concat CHAR(TIME(myTimeStampColumn), USA)