Re: Date conversion technique, alpha to Numeric

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Bob,

I may have missed it in the thread somewhere, but I would like a 
clarification as regards Date data types. 


My understanding is that the date is stored on disk in a binary format, 
and that it retains the same value regardless of the what DATFMT's value 
is.  That is, one program would have DATFMT(*ISO) and another program 
could have DATFMT(*USA) against the same table and that it is merely the 
presentation, say on a report or display, that differs. 


That, at least, seems to be the case from what I have read and from 
personal experience.  Corrections to ambiguities and/or errors in the 
above are welcomed.

Thanks.

        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Bob Cozzi wrote:
> There are many ways to do this.
> On is to call the QWCCVTDT API. This gives you the most flexibility.
> Another you can use a bunch of nested built-in functions, similar to the
> following:
>
>     YYMMDD = %Dec(%date(CCYYMMDD: *ISO0):*YMD);
>
> -Bob Cozzi
> www.i5PodCast.com
> Ask your manager to start watching i5 TV.
>