Re: Those flippin dates

The only thing that need to watch out for is that this method requires
the date to be valid date. Otherwise the program will fail. You could
monitor for this and handle it differently if you cannot be sure that
date is always valid.



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Wednesday, September 05, 2007 4:04 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Those flippin dates

Thanks to all for all the suggestions. I finally settled on:

@numa = %dec(%char(%date(@numd:*mdy):*ymd0):6:0); //mmddyy to yymmdd

for this. It was compact and just understandable enough to get me by.

I also wonder about execution time but in this particular SQL update
there shouldn't be more than a few hundred records (at most) to process.

Pete


Jerry Adams wrote:

That I like! Elegant yet simple yet understandable. Hard to beat and all of the bases covered.

The only thing I would be interested in now is any comparisons to the data structure method as regards time required to execute.


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

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.